FiveTech Software tech support forums

Thanks for your reply.
Indeed, I have seen that the problem is the SQL syntax. I am very used to using MySql for web purposes. Now it's time to learn MSSQL to be able to advance in FiveWin Harbour.

... MySql support GROUP BY without aggregate functions. But all providers /databases do NOT support GROUP BY clause without Aggregate functions like MSSQL.ORACLE, Jet,ACE, etc While dealing with DBF, we are concerned with Jet Oledb/ACE Oledb/VFPOLEDB. None of them support GROUP BY clause without ...

...  local oCn, cSql, oRs                                       // server      // db     // user   // pwd   oCn := FW_OpenAdoConnection( "MSSQL,208.91.198.196,gnraore3_,fwhmsdemo,fwh@2000#", .t. )   if oCn == nil      ? "failed to connect"   else      cSql := "INSERT ...

MySql : LIMIT n
MsSql : TOP n

... and if it is NOT, is there a way to reestablish connection? Here is my sample code establishing connection. oCn := FW_OpenAdoConnection( "MSSQL,"+xSOURCE+","+xDATABASE2+","+xUSERID+","+XPASSWORD, .T. ) if oCn == nil ? "Failed to connect to Server" ...

I understand you are using ADO with MSSQL (Microsoft SQL). Right? We can not say why are you not able to save, unless we test your program at our end. For this purpose, FWH provides an MSSQL server in the Cloud. You can connect to this server ...

This is not true:

Yes, not true for MsAccess, MSSQL and ALL other RDBMS with ADO.
But true for Excel ADO recordset

1) I am using MSSQL
2) FWH 23.04
3) xHarbour 2022 Bld773

I am trying postgres v.8 too

thank You

1) Are you using MySQL with ADO? Or MSSQL with ADO?
2) Your FWH Version? Harbour or xHarbour?
3) If you are using MySql, did you try FWH built-in MySql library?

... yield. Is there a tool to test your SQLs with Maria DB similar to Advantage ARC? MySql WorkBench for mysql/mariadb HeidiSql for mysql,mariadb,mssql,sqlite,PostGre Microsoft Studio for MSSQL Oracle sql developer, dbForge studio for Oracle and many many others Is the fwh ADO class good as well ...

... a given statement would yield. Is there a tool to test your SQLs with Maria DB similar to Advantage ARC? 2. Is the fwh ADO class good as well for MSSQL or is this only for MariaDB? Thank you.

jpcavagnaro wrote:La idea es sql server en los 2 casos.

Saludos
Jorge

MSSQL (Microsoft SQL sever) ?
OR
MySQL server?

Mr Rao, I have Fivewin 19.12, Can I request recordsets from MSSQl using parameter with my versión? Using the code: cCadsql1:="SELECT e.ITEMNMBR, a.ITEMDESC, e.LOCNCODE, e.QTYONHND, e.ATYALLOC, e.QTYONHND - e.ATYALLOC, a.SELNGUOM, IV40201.baseuofm,"+;" ...

my dbf using codepage 'PLMAZ'
and I want to move dbf to mysql or mssql where codepage is 'PLWIN'

maybe, there is codepage parameter

No.
Can you please explain what exactly are you looking for?
Are you working with MSSQL?