Postby mmi_rqm » Thu Apr 16, 2015 3:00 pm
I've a problem with GUID columns in SELECT statement. Statement like this:
will return only odd rows from database on SalTblPopulate or on SqlFetchNext. That means if in DB I have:
result with SalTblPopulate or SqlFetchNext would be:
I'm working on Team Developer 5.2-SP3, on virtual machine with windows XP, but application acts the same on windows 7 and windows 8.
Databases are on SQL Server 2012 and SQL Server 2008 R2 and both have problem with GUID (uniqueidentifier).
On Oracle there is no problem since there GUID is char(36).
Here is a test case. Just execute query.sql on your DB and insert appropriate parameters for DB connection in Go() function.
Have anyone come across to this problem?
The latest version is 5.2 sp5. It would start with patching your version 5.2 sp3.
However try this :
Set SqlDatabase = "regina"
Set SqlUser = "sysadm"
Set SqlPassword = "sysadm"
Call SqlConnect( hSql )
Call SalTblPopulate( tbl1, hSql, "SELECT gid FROM some_table", TBL_FillAll )
Call SqlDisconnect( hSql )
Who is online
Users browsing this forum: [Ccbot] and 0 guests