corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » Realbasic


New Topic

New Poll
  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Realbasic
Jodi_the_g
Member

Registered: 7th Aug 01
Location: Washington D.C
User status: Offline
5th Feb 08 at 13:21   View User's Profile U2U Member Reply With Quote

Been a while since I worked out of .net but need a multi platform app so using realbasic.

With DB's how do you get the next primary key

code:

// add to database
dim dr as new DatabaseRecord

dr.Column("date")=trim(RecordDate.text)
dr.Column("glider")=trim(GliderCombo.text)
dr.BooleanColumn("ground")=sground
dr.BooleanColumn("mountains")=smountain
dr.Column("event")=trim(EventBox.text)
dr.Column("length")=trim(LengthBox.text)
dr.Column("description")=trim(DescriptionBox.text)

gliderdb.InsertRecord "record", dr
gliderdb.Commit




I can remember doing it years ago and EOF commands ring a bell just can not rememeber.
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Online
5th Feb 08 at 13:40   View Garage View User's Profile U2U Member Reply With Quote

EOF means end of file, which is what you don't want.

You need to know record pointer syntax. Never used that language.
Jodi_the_g
Member

Registered: 7th Aug 01
Location: Washington D.C
User status: Offline
5th Feb 08 at 13:42   View User's Profile U2U Member Reply With Quote

Me either Ian its close to c++ so am winging it.

It just the inbuilt database for it is limited funtion wise, so everything has to be manual
MikeLamb
Member

Registered: 23rd Sep 03
Location: Crowthorne Drives: Veccy SRI
User status: Offline
5th Feb 08 at 18:38   View User's Profile U2U Member Reply With Quote

somethig lie movenext??

 
New Topic

New Poll

Corsa Sport » Message Board » Off Day » Geek Day » Realbasic 24 database queries in 0.0086060 seconds