Android Question RDC: Conversion failed when converting datetime

Pisinho

Active Member
Licensed User
Longtime User
Hi,
My server is Ms Sql Server 2005.
When send a query to server RDC with field datetime , server give me a error:

java.sql.SQLException: Conversion failed when converting datetime from character string.

in my code :

GetPartenzaVolo(EditText1.text, EditText2.text)


Sub GetPartenzaVolo(Partenza As String, Data As String)
Dim cmd As DBCommand
Dim datavolo As Long
cmd.Initialize
cmd.Name = "select_partenza_data"
'datavolo = DateTime.DateFormat(Data)

cmd.Parameters = Array As Object(Partenza, Data)
reqManager.ExecuteQuery(cmd, 0, "OK")
.
.
.
query on config.properties.
sql.select_partenza_data=SELECT * FROM TABLE WHERE PARTENZA = ? AND DATE = ?


Help me...
 
Top