![]() ![]() I had to tweak all the queries for sql server, mostly because of differences in how the new PK is returned from an INSERT, differences in how fields are quoted, etc. The same query works on MacOS when I run the app there, but that’s talking to Postgres. Getting away from prepared statements solved his issue. ![]() In his case he was using “prepared statements”, which I’m not. Per TOF, this “only returns one row” issue was happening to some poor soul back in 2019. There is no TOP n clause, there is no WHERE clause, it’s equivalent to SELECT * FROM TableName, and from SSMS I can see nearly 6K records in that table. I perused TOF and found people talking about installing old versions of the native client and I said, feh, let’s just try ODBC instead.Īfter some futzing with the the system DSN (Xojo was opening the master DB despite me setting the desired Db property in the OdbcDatabase class I had to select that at the system DSN level) I now have a query that should return several thousand rows, only returning the first row. Began by whining about the native client not being installed, when in fact Sql Server developer edition in its entirety is directly on that box. So I have Xojo up and running on Windows Server and as per some of the discussion above, the native SqlServer plugin just seems more trouble than it’s worth.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |