kevinw
SQL Server - How To Get Number Of Rows Updated May 28, 2008 06:53PM |
kevinw
Re: SQL Server - How To Get Number Of Rows Updated June 03, 2008 06:31PM |
Ben
Re: SQL Server - How To Get Number Of Rows Updated June 03, 2008 08:49PM |
Ben
Re: SQL Server - How To Get Number Of Rows Updated June 03, 2008 10:12PM |
Art Bonds
Re: SQL Server - How To Get Number Of Rows Updated June 03, 2008 10:14PM |
Leo Voet
Re: SQL Server - How To Get Number Of Rows Updated June 04, 2008 09:19AM |
kevinw
Re: SQL Server - How To Get Number Of Rows Updated June 04, 2008 10:27AM |
Ben
Re: SQL Server - How To Get Number Of Rows Updated June 04, 2008 12:48PM |
kevinw
Re: SQL Server - How To Get Number Of Rows Updated June 04, 2008 02:19PM |
Firetox
Re: SQL Server - How To Get Number Of Rows Updated June 04, 2008 04:30PM |
kevinw
Re: SQL Server - How To Get Number Of Rows Updated June 04, 2008 05:44PM |
Quote
Firetox
in you case :
SQLExec("UpdateClient where client_ID > 1000 ........)
SQLExec("select @@rowcount")
then the SQLCol(maReq,1) give you the number of row updated
it work fine with SQLServer Express 200(
/quote]
Can you please show me all of the code in this area - I keep getting WinDev errors (the SQLExec() needs a second parameter, I think you need to put something else before SQLCol() and what is maReq1).
TIA, Kevin
Firetox
Re: SQL Server - How To Get Number Of Rows Updated June 04, 2008 05:57PM |
kevinw
Re: SQL Server - How To Get Number Of Rows Updated June 04, 2008 06:28PM |
Firetox
Re: SQL Server - How To Get Number Of Rows Updated June 04, 2008 06:33PM |
Leo
Re: SQL Server - How To Get Number Of Rows Updated June 05, 2008 11:24AM |
Firetox
Re: SQL Server - How To Get Number Of Rows Updated June 05, 2008 11:50AM |
Firetox
Re: SQL Server - How To Get Number Of Rows Updated June 05, 2008 11:54AM |
Quote
This allways will work on any ansi SQL based DB;
Way make things difficult if they can be so easy ?
Leo
Re: SQL Server - How To Get Number Of Rows Updated June 06, 2008 08:47AM |
Firetox
Re: SQL Server - How To Get Number Of Rows Updated June 06, 2008 09:07AM |
kevinw
Re: SQL Server - How To Get Number Of Rows Updated June 06, 2008 03:29PM |
Firetox
Re: SQL Server - How To Get Number Of Rows Updated June 06, 2008 03:48PM |
AccesDatabase is a c_MSSQL4WD()
LOCAL v_retCode is boolean v_retCode = MSSQL:mySQLConnecte("Provider=SQLOLEDB;server=FREDERIC\SQLEXPRESS;UID=sa;PWD=fred;database=testSQLserver;") IF not (v_retCode) THEN Erreur("Impossible de se connecter à la base de donnée 'test'.", MSSQL:mySQLGetErrorMessage())
LOCAL retCode is boolean custom_ID is int custom_Name is string custom_date is string retCode = MSSQL:mySQLExec("SELECT NumEntree, NumFournisseur, DateEntree FROM ENTREES limit 10,20",0) IF (retCode) THEN MSSQL:mySQLPremier(0) WHILE (NOT MSSQL:mySQLEnDehors) custom_ID = MSSQL:mySQLLitCol(0, 1) custom_Name = MSSQL:mySQLLitCol(0, 2) custom_date = MSSQL:mySQLLitCol(0, 3) trace( custom_ID + TAB + custom_Name + TAB + custom_date) MSSQL:mySQLSuivant(0) END ELSE Info(MSSQL:mySQLGetErrorMessage()) END MSSQL:mySQLFerme(0)
LOCAL retCode is boolean TableSupprimeTout(TABLE1) retCode = MSSQL:mySQLExec("SELECT NumEntree, NumFournisseur, DateEntree FROM ENTREES order by NumEntree desc", 0) IF (retCode) THEN MSSQL:mySQLTable(0, "TABLE1") MSSQL:mySQLFerme(0)
description est une chaîne IF MSSQL:MySQLDecritTable(table_adox, ma_description) THEN Info (Remplace(description,"/", ""+RC+""))
kevinw
Re: SQL Server - How To Get Number Of Rows Updated June 06, 2008 05:50PM |
firetox
Re: SQL Server - How To Get Number Of Rows Updated June 06, 2008 06:01PM |
kevinw
Re: SQL Server - How To Get Number Of Rows Updated June 10, 2008 11:58AM |