Android Question jrdc2

[sodavica]

hi
im starting to learn ...
On client side i use
Dim cmd As DBCommand = CreateCommand("sql.insert_test", Array(Name,Name))

b4j
config.properties
sql.insert_test=INSERT INTO test VALUES (?, ?)

error
*** Command not found: sql.insert_test
(PSQLException) org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0.
(IllegalStateException) java.lang.IllegalStateException: WRITER
Command: , took: 9ms, client=172.16.1.18
Thanks, Stane

 

[Erel]

Please use [code]code here...[/code] tags when posting code.

The command name should be "insert_test" not "sql.insert_test"

 

[sodavica]

Thanks, a lot.
Can you please give me an example how to insert timestamp from B4A?

 

[Erel]

B4X uses ticks (Longs) to represent time instances. You can convert the ticks value to a date or time string with DateTime.DateFormat and DateTime.Date.

You can then use the TO_TIMESTAMP command in your SQL command to convert the string to a timestamp: https://www.postgresqltutorial.com/postgresql-to_timestamp/