Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to retrieve last or first record from MySQL table ?
Message
From
13/02/2009 05:31:43
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
13/02/2009 03:35:52
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MySQL
Miscellaneous
Thread ID:
01381516
Message ID:
01381526
Views:
45
>Hii, I am really new in using remote data and I really need some help.
>
>How to retrieve last or first record from MySQL table ?
>How to navigate in MySQL table just like using skip command ? eq. skip 1, skip -1, go top, go bottom
>
>Thanks

As Sergey points out, once you work with client-server you have to get accustomed to a completely different way of working.

In a table on a database server, there isn't even a "first" or "last" record (unless you have a special field for this purpose). You access records by key values.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform