lingbl

Results 10 comments of lingbl

thankyou , my question is not smart , I load fastq file, it is allways very big. By the way , why lua have to mix array and hash ,...

fine , this a way to skip some head lines

I compile luasql in mysys2 mingw32, should I use visual studio ???

I replace float by varchar(20) in database, the luasql can work properly https://learn.microsoft.com/en-us/answers/questions/1091666/kb5019959-sqlserver-instruction-isnullamount0-some.html

SQLcmd = "select Week from Production_2011 where Production_LOTNO = '20221123N7E'" luaopen_luasql_odbc()... create_metatables()... create_environment()... env_connect()... create_connection()... conn_execute()... conn_prepare()... desc_params()... raw_execute()... create_cursor()... create_colinfo()... sqltypetolua()... type:6 sqltypetolua(): number cur_fetch()... getcursor()... SQLFetch()... cur_fetch():num 1...

Use float instead of double, that too small ! /* deal with data according to type */ switch (type) { /* nUmber */ case 'u': { printf("push_column(): nUmber\n"); /*SQLDOUBLE num;...

the luasql can get data "Week" correctly , when use SQL_C_FLOAT , by the way this is not my idea https://stackoverflow.com/questions/74447805/sqlgetdata-doesnt-work-in-the-same-way-after-install-kb5019959 https://stackoverflow.com/questions/74451813/unknown-token-received-from-sql-server-error-just-started-happening-on-windows?r=SearchResults&s=3%7C21.8408 The data "Week" store in MSSQL as "float"...

Thank you Tomás !! , If this is a bug from patch, I will wait next patch to fix it. Change "float" type to "numeric(18, 6)" in MSSQL may be...

Install microsoft odbc driver , and reset DSN.

https://github.com/qgis/QGIS/issues/50865#issuecomment-1314973751