View Single Post
  #3 (permalink)  
Old October 11th, 2003, 12:39 PM
happygv happygv is offline
Friend of Wrox
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post


I remember that I used a lot of times something similar to this and had no problems as U.N.C.L.E ;) had faced.

Here is what I have done recently.

Query=SELECT MAX(ProductId)+1 AS NewProductId FROM Products

And have accessed it using


Which worked... and was able to use its value for inserting a new record into Products.

Also used COALESC function in many occasions and accessed its values as Aliases.

Just wondering!!!...

This is somthing that we could face manytimes going for aliases, in case there is a necessity to access a userdefined column but not the original column from the table itself.

E.g. - May be as I mentioned above one may need to get the incremneted value from the table or sometimes would try to calculate something from the table and try to get it back as aliases in the frontend.

Hope this is what U.N.C.L.E would have tried to do.

Still eagar to hear his explanations, as I dont see any calculations done in his case.

-Vijay G
Reply With Quote