FiveTech Software tech support forums

March-April 2024 ================ * New: Support for local AI LLM (large language models) using llama.cpp that has been included in FWH. Please review samples\llm.prg. In order to test it you have to download tinyLlama.gguf from here: https://huggingface.co/fivetech/tinyLlama/blob/main/tinyLlama.ggu...

Hola gente, me pueden decir que estoy haciendo mal: xdrive := curdrive() + ":\" + curdir()+"\esp" oCn := FW_OpenAdoConnection( { "FOXPRO", xdrive}, .T.) cSQL := "select top 10 Cliente, Fecha, licita, descrip, cantidad, devol from detlici where codigo = '00024' orde...

Si, es mas reciente que la mia
La que yo tengo la function Fw_OpenAdoConnection( cConnStr, lShowError, oErr ) acepta esto tres valores, cadena, mostrar o no error, y el error obtenido (para pasar como referencia)
Fijate en sources\function\adofuncs.prg si tiene otros parametros

Mr. Rao, sigue el mismo error Error description: Error ADODB.Connection/0 S_OK: EXECUTE Args: [ 1] = C INSERT INTO prueba (cliente,Numero) VALUES ( 0, 21) Stack Calls =========== Called from: => TOLEAUTO:EXECUTE( 0 ) Called from: abd4.prg => MAIN( 58 ) en el dbf prudbt inserta el registro sin ...

Hola, tengo este programa y no entiendo porque me da error el segundo insert: #include "FiveWin.ch" REQUEST HB_LANG_ES function Main() local oCn, oCnM, oRs, aStates LOCAL lShowError := .t. /* dbcreate( ".\prudbt", { { "id" , "n", 8, 0 }, ; { "Cliente &quo...

Thank you Rao

"ServerAddress:port"

eg:

Code: Select all  Expand view

190.30.20.20:3306

Hello Rao
how to specify the port with FW_OpenAdoConnection() ?

Maurizio

Code: Select all  Expand view

oCn := FW_OpenAdoConnection( "MSSQL,"+xSOURCE+","+xDATABASE2+","+xUSERID+","+XPASSWORD, .T. )

We can also write like this:

Code: Select all  Expand view

oCn := FW_OpenAdoConnection( { "MSSQL", xSOURCE, xDATABASE2, xUSERID, XPASSWORD }, .T. )

Thank you Rao

Please check the value of oCn:State. If the value is 0, the connection is closed. If the value >= 1 the connection is open and the actual value depends on the current activity. If oCn is closed we can try reconnect by oCn:Open() This is a sample code to check the connection status and try to reco...

Hello Everyone, Is it possible to determine if FW_OpenAdoConnection is still alive before a FW_OpenRecordSet call and if it is NOT, is there a way to reestablish connection? Here is my sample code establishing connection. oCn := FW_OpenAdoConnection( "MSSQL,"+xSOURCE+","+xDATABAS...

Hola gente, tengo una dbf generada con la estructura así: dbcreate( ".\auditado", { { "id" , "n", 8, 0 }, ; { "Cliente " , "n", 6, 0 }, ; { "Nro_Audit" , "n", 6, 0 }, ; { "Numero " , "n", 6, 0 }, ; { "Lide...

If you are working with MSACCESS oRs:Filter := "LDATE >= #2023-01-01# AND HDATE < #2023-02-01#" If you are working with Microsoft SQL oRs:Filter := "LDATE >= '2023-01-01' AND HDATE < '2023-02-01'" Note: It is safer to use "HDATE < (date + 1 )" than "...

jose_murugosa wrote:Mr. Rao

Thanks a lot for your help, I'm starting with ado connections and your feedback is really appreciated.

Muchas gracias por su ayuda, estoy comenzando con las conexiones ado y su devolución es muy apreciada.

Thanks a lot,
Muchas gracias.

We assure our full support.