U++ framework: U++ SQL » SqlArray Join

Home » U++ Library support » U++ SQL » SqlArray Join

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Sat, 22 July 2006 07:42

rbmatt
Messages: 90
Registered: July 2006
Location: Tennesse, USA

Member

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?

Attachment: EzellApp4_v2.zip
(Size: 3.51KB, Downloaded 1881 times)

Report message to a moderator

[Message index]

		SqlArray Join By: rbmatt on Wed, 19 July 2006 02:47
		Re: SqlArray Join By: rbmatt on Wed, 19 July 2006 07:27
		Re: SqlArray Join By: mirek on Wed, 19 July 2006 11:11
		Re: SqlArray Join By: rbmatt on Wed, 19 July 2006 17:07
		Re: SqlArray Join By: mirek on Wed, 19 July 2006 17:13
		Re: SqlArray Join By: rbmatt on Wed, 19 July 2006 18:36
		Re: SqlArray Join By: mirek on Wed, 19 July 2006 21:17
		Re: SqlArray Join By: rbmatt on Wed, 19 July 2006 22:53
		Re: SqlArray Join By: mirek on Wed, 19 July 2006 23:48
		Re: SqlArray Join By: rbmatt on Thu, 20 July 2006 00:09
		Re: SqlArray Join By: rbmatt on Fri, 21 July 2006 06:35
		Re: SqlArray Join By: mirek on Fri, 21 July 2006 14:33
		Re: SqlArray Join By: rbmatt on Fri, 21 July 2006 17:16
		Re: SqlArray Join By: rbmatt on Sat, 22 July 2006 07:42
		Re: SqlArray Join By: forlano on Sat, 10 March 2007 18:44
		Re: SqlArray Join By: mirek on Sun, 23 July 2006 19:15
		Re: SqlArray Join By: rbmatt on Sun, 23 July 2006 19:49

Previous Topic:	ODBC ?
Next Topic:	MS SQL Server connection possible?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri May 15 04:16:06 GMT+2 2026

Total time taken to generate the page: 0.00805 seconds