Mongoose
January 31st, 2000, 02:25 PM
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,
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,