Re: [q-lang-users] ODBC connection with MS Access

[<jir...@bl...>]

Jiri Spitz wrote:
> ==> sql DB "insert into data_nrg_101a values ('c', 'c', 'c', 'c', 'c', 
> 123, ?)" ("")
> sql_exec <<ODBCHandle>> "insert into data_nrg_101a values ('c', 'c', 
> 'c', 'c', 'c', 123, ?)" ""
> Empty strings in parameters are not accepted, no error message.
> 
> ==> sql DB "select * from data_nrg_101a where flag = ?" (())
> odbc_error "[Microsoft][Ovladač ODBC pro Microsoft Access]Nesprávná 
> hodnota pole COUNT. " "07002"
> Selecting by NULL in parameter does not work. The error message means 
> "Invalid value of the field COUNT."

Sorry for that (one element tuples...), but does not work anyway:

==> sql DB "insert into data_nrg_101a values ('d', 'd', 'd', 'd', 'd', 
123, ?)" ("",)
sql_exec <<ODBCHandle>> "insert into data_nrg_101a values ('d', 'd', 
'd', 'd', 'd', 123, ?)" ("",)

==> sql DB "insert into data_nrg_101a values ('d', 'd', 'd', 'd', 'd', 
123, ?)" ((),)
sql_exec <<ODBCHandle>> "insert into data_nrg_101a values ('d', 'd', 
'd', 'd', 'd', 123, ?)" ((),)


Jiri