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...
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...