key problem

Results 1 to 3 of 3

Thread: key problem

  1. #1
    jon Guest

    Default key problem

    Hi All,<BR><BR>I have a problem. i want to generate the increment no. respect to username.<BR>if user have the null record in database then what how i will create first record.<BR><BR>jon

  2. #2
    Join Date
    Dec 1969

    Default Read the F.A.Q.'s

    You can thank Bill WIlkinson for this one ...<BR><BR>

  3. #3
    Raghuraja,Bangalore-1 Guest

    Default RE: key problem

    Try This Code<BR><BR> RecordSet.Open "Select Max(UserId) From Users",Connection,1,3<BR> If Not IsNull(RecoreSet(0)) Then<BR> MaxFId = RecordSet(0) + 1<BR> Else<BR> MaxFId = 1<BR> End If<BR> RecordSet.Close<BR> RecordSet.Open "Select * From Users",Conection,1,3<BR> RecordSet.AddNew<BR> etc<BR> etc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts