FiveTech Software tech support forums

... Error: Unresolved external 'AdsCloseSQLStatement' referenced from I:\HARBOUR\LIB\RDDADS.LIB|adsfunc Error: Unresolved external 'AdsExecuteSQLDirect' referenced from I:\HARBOUR\LIB\RDDADS.LIB|adsfunc Error: Unresolved external 'AdsPrepareSQL' referenced from I:\HARBOUR\LIB\RDDADS.LIB|adsfunc ...

... click on the OK button to close it. So the program execution is stopped until you close the error message. And this happens also when you use the AdsExecuteSQLDirect function. Thanks a lot Massimo

... class to execute SQL statements with ADS. You could simply use ACE API functions. To execute a sql statement using the API simply call function AdsExecuteSqlDirect( cSql ), where cSql is a string parameter with the sql you want to execute. The class itself is only a wrapper to ease the use of ...

Rinaldo, Javier: Gracias por responder Lo que quiero es "ANIDAR" el ADSExecuteSQLDirect() En el ejempo que pone Javier, lo que quiero hacer es:     Select 0    ADSCreateSQLStatement("MIALIAS",3)    cSQL := "SELECT {static} * from ...

... AM", //CIERRA el cursor   AdsExecuteSQL( hSQL, &hCursor ); AdsCloseTable( hCursor ); AdsClearSQLParams( hSQL ); AdsExecuteSQLDirect( hSQL, "Select lastname from Demo10", &hCursor ); //CREA otro cursor, sin cerrar el AREAAdsGotoTop( hCursor ...

... PROD_CON.ID_PROD, PROD_CON.REFEREN, PROD_CON.STATUS, CAT_PROD.NOM_PROD From PROD_CON, CAT_PROD WHERE CAT_PROD.ID_PROD = PROD_CON.ID_PROD" AdsExecuteSqlDirect(cQuery) Index On STRZERO(ID_PROD,5) TAG "ID" TO (cAlias) Select(cAlias) (cAlias)->(OrdSetFocus("ID")) (cAlias)->(dbGoTop()) ...

... PROD_CON.ID_PROD, PROD_CON.REFEREN, PROD_CON.STATUS, CAT_PROD.NOM_PROD From PROD_CON, CAT_PROD WHERE CAT_PROD.ID_PROD = PROD_CON.ID_PROD" AdsExecuteSqlDirect(cQuery) Index On STRZERO(ID_PROD,5) TAG "ID" TO (cAlias) Select(cAlias) (cAlias)->(OrdSetFocus("ID")) (cAlias)->(dbGoTop()) ...

Hola Al parecer esta correcto, ahora habria que ver que error te esta dando ADS coloca esta instruccion despues de AdsExecuteSqlDirect MsgInfo("error AdsExecuteSqlDirect(cSql)" + CRLF + "Error:"+cValtochar( AdsGetLastError() ) ) y veamos ...

... order by utente" Select 0 ADSCReateSqlStatement("Utenza", 1) Register_CallBack( { | nPercent | agg_meter(@ometer, nPercent) } ) ADSExecuteSQLDirect(stringa_sql) Unregister_callback() browse() return nil ******************************************* STATIC FUNCTION agg_meter(ometer, ...

... los datos del DBF temporal creado por ADS con el resultado de la consulta, ¿debo repetir la operación o hay algo parecido a un Refresh() del ADSExecuteSQLDirect( cSql )?. Muchas gracias. function Test_SQL()   LOCAL cSql   := ""   LOCAL aArray := ...

Hi Armando,

Try this:

Select 0
ADSCReateSqlStatement("hStatement",1)
ADSExecuteSQLDirect("CREATE TABLE Meses( " +;
"Numero Numeric(3,0)," +;
"Descripcion Char(10)) IN DATABASE")

Bye.
Giuliano

Fraxi; Yes you are right. I'm simplifying. I'm sorry. I have a function based on ADSExecuteSQLDirect() that returns an array instead of a cursor with the values. *-------------------------------------------------------------------------------------------------------------------------------function ...

... Would work with ADS, as well as: cSql := "SELECT field1, field2 from table where keyfield = '" + cKey + "'"aResultSet := ADSexecuteSQlDirect( cSql )  ... Hello Reinaldo, aResultSet := ADSexecuteSQlDirect( cSql ) on which version of ADS this returns an array ...

... Regards Anser Hello Anser, The array contains the field (column) or values. Is there a better approach than iterating AdsExecuteSQLDirect() ? Regards, Fraxzi

... Error: Unresolved external 'AdsCloseSQLStatement' referenced from C:\FIVETECH\XHARBOUR\LIB\RDDADS.LIB|adsfunc Error: Unresolved external 'AdsExecuteSQLDirect' referenced from C:\FIVETECH\XHARBOUR\LIB\RDDADS.LIB|adsfunc Error: Unresolved external 'AdsPrepareSQL' referenced from C:\FIVETECH\XHARBOUR\LIB\RDDADS.LIB|adsfunc ...