GeoCoder library and GetFromLocation() parameter (Tag) error

[nitinb4a]

Hi Erel,

I am trying to run B4A sample program for GeoCoder library url given below and copied the button click code given by "WARWOUND" and it is giving below error.
------------------------------------------------------------------------
http://www.b4x.com/forum/additional...updates/17115-geocoder-library.html#post97857

Parsing code. 0.00
Compiling code. Error
Error compiling program.
Error description: Missing parameter.
Occurred on line: 69
Results=Geocoder1.GetFromLocation(Latitude, Longitude, MaxResults)
Word: )
--------------------------------------------------------------------------
What value should I pass as TAG?

BR
Nitin:sign0085:

 

[Erel]

You cannot omit a parameter. You can pass Null.

 

[nitinb4a]

GeoCoder library Missing parameter

Thanks

Now the code is working fine !

BR Nitin

 

[nitinb4a]

MSSQL Library exception on insert query

Hello Erel,

I am working on MSSQL library and developed one b4a program for same and below insert query statement is saving record in remote MS Sql 2005 database server table but it is giving one Exception as given below.

SQL1.Query("INSERT INTO A_LocMaster2 VALUES('"& varImei &"', "& varlon &" ,"& varlat &",'"& varLocaddress &"','"& VarUpdateDate &"','"& varTime &"')")

java.sql.SQLException: java.sql.SQLException: The executeQuery method must return a result set.

How to handle this Exception ?

BR
Nitin
:sign0085:

 

[Erel]

Please start a new thread for this question.

 

[nitinb4a]

MSSQL Library exception on insert query

Hi Erel,

"hasanaydin52" has given solution for the same.

The problem is solved now..

Thanks & BR
Nitin