Recent content by djasy3

@david: i use the Dmax and it worked perfectly! thanx buddy

ok, it's fine! thanks anyway for your replies. if i can have the value with the querry, it's already good(with the select top...) it's time now to deal with the C# side! thanks! :)

@David, i'm calling the procedure in a C# file, through a method. what i want to do is to save the query in access so that i may be able to call it from the c# file and retreive the value from there and then pass it to another query. the application is with Asp.net that's why i cant write the vb...

@David R, thanks, but if i execute the query, a prompt box appear asking to enter a value of request1.Expr1000. but it gives me the result any way even if i don't put something in it!

OK! so how can i retreive the last generated number from a table in a querry? i tried with this : select @@identity from Table_Name, but it gives me column with 15 zeros. cos 15 was the last generated number in my table.

hi, i'm using a sql procedure which i'd like to implement the equivalent in ms access. i'm not very good at access but i want to know if they can be any possibilities. this is my procedure CREATE PROCEDURE CreateOrders (@cartId char(36)) As DECLARE @CmdID int INSERT INTO Commande DEFAULT...

thank you! CJ

Thanks CJ_London, the thing is i'm using C#. Or, IS there any other way to write the querry in access with the :" WHERE EXISTS" clause?

ShoppingCart is an Access db, i wanted to create a query which will help me to access to the database through the C# code when creating parameters. !

hi, i'm developping a website under Asp.Net C# with an access database, but i'm having a trouble to use a query that need to verify if some informations exists in the database, if not then insert into the table, but i have the code in sql which is not accepted in access. i want to know if...

hello, i'm Djasy from Canada, and i'm a new member i'm a student !