Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert address
Message
From
16/07/2011 18:02:04
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
15/07/2011 20:39:55
Muthu Vel
Sty Company
India
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01518328
Message ID:
01518376
Views:
54
>I have table "Insertaddress.dbf" with fields 1. regno (C) 2. Name (C) 3. Rank (Integer) 4. address (Blob) and i already created 500 records staring from regno 20001 to 20500.
>
>I have student address as OMR scanned image Jpeg format, the location is "E:\Muthu\address" total 500 address and each address bind with regno.
>
>how to insert each address against their regno into my table of address field programmatically ?

I am not sure exactly what you want to achieve. You can insert records with INSERT INTO..., or with APPEND BLANK followed by REPLACE.

You can get a list of files from a folder with adir(). You would have to write a loop to process each filename.
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