U++ forum: Welcome to the forum

Re: SqlArray Join [message #8450 is a reply to message #4117]

Sat, 10 March 2007 18:44

forlano
Messages: 1207
Registered: March 2006
Location: Italy

Senior Contributor

rbmatt wrote on Sat, 22 July 2006 07:42

Ok, so I worked through several things today.
I added schema support so while in debug mode it will update my schema based on the .sch file. Then I use sch to automatically define all my SqlId's.
I found out why I was having a problem with data reverting to old states. Got that (mostly) fixed.
I don't think there is a way for me to manually make the changes to the database (short of actually writing the code Wink

). What I mean is UpdateRow() is protected so I cannot call it. There are no member functions that say "write this to the db" that I see.
Also inserting does not seem to be working. I traced the code as best I could.
The program does a late insert but somehow it looks like it only wants to do an update. The update code looks like:
update CUSTOMERS set NAME = 'test', ADDRESS = NULL, CSZ = NULL, PHONE1 = NULL, NAME = 'test' where ID is NULL
Well, there is no entry where ID is NULL so nothing happens.
And to get the autonumber we need to set ID = NULL which it does not do.
I've attached my new version.
Thanks.
P.S. What are the lines in the DocEdit? Is there a way to turn that off?

Hello,

I was unable to compile the package with 2007.1.rc2.
Perhaps something changed during these months. Any hope to fix it? I remind I was able to compile it with old version. Now all the complains come from the .sch file.

Luigi

Report message to a moderator