[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

database programming

Posted on 1999-11-27
3
Medium Priority
?
218 Views
Last Modified: 2010-04-27
Does any body have a good resourse for syntax for recordsets  the info in my textbook is absolutely useless
ie
adding records
reading records
changing current
0
Comment
Question by:pharmatic
  • 2
3 Comments
 
LVL 2

Accepted Solution

by:
mflam earned 50 total points
ID: 2241934
You change the properties of your data object, so you point to the correct type of database (Access for example) to the correct db file (mydb.dbf for example) and using the correct table (workers for example).
Give the "data" a name (myData for example).

Now you write
 myData.recordset.moveFirst
 while (not EOF myData)
  i = myData.recordset.fields("hatcolor").value
  j = myData.recordset.fields(2).value
  myData.recordset.fields(3).value = "boo"
  myData.recordset.update ' needed only after writing to field, not for reading.
' If you had not used write, you would not use the ".update" .
 endw

Hope this helps, Moshe
0
 

Author Comment

by:pharmatic
ID: 2242254
Not a lot ofg info there but I get the picturee,  found some info in bassic for dummies about the most concise starter book out there
0
 

Author Comment

by:pharmatic
ID: 2242256
If you have any other info on database programming please let me know
0

Featured Post

SMB Security Just Got a Layer Stronger

WatchGuard acquires Percipient Networks to extend protection to the DNS layer, further increasing the value of Total Security Suite.  Learn more about what this means for you and how you can improve your security with WatchGuard today!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A clone is a duplicate copy. Sheep have been cloned and maybe someday even people will be cloned, but disk cloning (performed by the hard drive cloning software) is a vital tool used to manage and protect data. Let’s look at what hard drive cloning …
This article shows how to use a free utility called 'Parkdale' to easily test the performance and benchmark any Hard Drive(s) installed in your computer. We also look at RAM Disks and their speed comparisons.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
Suggested Courses

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question