Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Store image path in dbf
Message
 
To
15/09/2004 04:03:02
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00942247
Message ID:
00942292
Views:
18
thisform.image1.picture=getpict()
thisform.text1.value=thisform.image1.picture

Select table1
calculate max(sno) to abc
abc=abc+1
append blnak
replace sno with abc
full_path = thisform.image1.picture
IF LEFT(tt1,2) == "\\"
   full_path = SUBSTR(full_path,3) && remove "\\"
   nAt       = AT("\", full_path) 
   full_path = SUBSTR(full_path,nAt+1) && remove mapped drive name
   nAt       = AT("\", full_path) 
ELSE
   full_path = SUBSTR(full_path,4) && remove drive letter - > d:\
   nAt       = AT("\", full_path)
ENDIF
pict_path = SUBSTR(full_path,nAT+1)
replace path with pict_path
(not tested)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform