|
-
January 31st, 2000, 03:25 PM
#1
RDS ADOR.Recordset
Has anyone had the following problem?
I'm trying to do the following
dim RS as new ADOR.Recordset
RS = GetData( "SELECT LastName, FirstName, Age FROM Employee" )
RS.AddNew
RS.Fields(0).Value = "Smith"
RS.Fields(1).Value = "John"
RS.Fields(2).Value = 29
RS.Update
... NOW LOOK AT THE DIFFERENCE WITH THIS PROCEDURE BELOW
RS = GetData( "SELECT LastName + ", " + FirstName AS FullName, Age FROM Employee" )
RS.AddNew
RS.Fields(0).Value = "Smith, John"
RS.Fields(1).Value = 29
RS.Update
Now the application BOMBS (with no error description) after I do the .AddNew (when I set the value for the first field (FullName) on the second example.
I know this is because I'm using an Alias, etc.. but I NEED The program to work this way!!! How can I get the application not to crash???
Thankx,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|