Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #55.0K
3 Posted Topics
If i understand you, what you need is for the program to give the next open id number, you put auto increment in the id details in the database, open a new record, and ask the database what was the id it created. This is the id you use for …
put auto increment in the data field of the data base. every database has this option.
some thing like this SELECT Shippers.ShipperName,COUNT(Orders.OrderID) AS NumberOfOrders FROM Orders LEFT JOIN Shippers ON Orders.ShipperID=Shippers.ShipperID GROUP BY ShipperName; look here : http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_groupby
The End.