Re: I need update images without Requery
Started by JCAK at 12-13-2006 18:21. Topic has 4 replies.
|
|
12-13-2006, 18:21
|
JCAK
Joined on 12-13-2006
Posts 4
|
I need update images without Requery
|
 
 
|
|
|
|
Hi
I'm using LEADTools 14 and 13 and all works fine but I need help with the following:
How can I save images into my Access database without "requery". I'm trying using "Update" like usually I do with any recordset, but don't work and the binary field remain empty.
All the LEAD samples show the requery and I don't understand why?
The following code works finde, but only if I use the requery sentence. A reqeury with a lot of records does this very slow. Could you help me please ???
Adodc1.Recordset.AddNew LEADRasterOLEDB1.Raster = LEADRasterView1.Raster LEADRasterOLEDB1.DataDirty = True Adodc1.Recordset.Update Adodc1.Recordset.Requery LEADRasterOLEDB1.DataDirty = false
Thank you
|
|
|
|
|
Report
|
|
|
|
12-14-2006, 8:27
|
Bashar

Joined on 08-27-2003
Posts 1,057
|
Re: I need update images without Requery
Attachment: VBOLEDB.zip
|
 
 
|
|
|
The image is saved to the DB without calling Requery on my side.
See attached sample. Use the same DB from the tutorial.
Bashar Abdulqaiyume LEAD Technologies, Inc.
|
|
|
|
|
Report
|
|
|
|
12-14-2006, 13:47
|
JCAK
Joined on 12-13-2006
Posts 4
|
Re: I need update images without Requery
|
 
 
|
|
|
Hi Bashar
I'm trying your suggestion, with your sample and the database leadpic.mdb but I have the same problem. Without "Requery" or "Move 0" the recordset is not updated.
Please, try the following:
1) Remove the line Requery
2) Run the sample and Add Photo (Before load the photo don't move the ADO recordset)
3) Close application (Please don't move the ADO recordset before this)
4) Run the sample again, search for the new recordset and you could see the “photo” field empty and the “Who” field with your file path information.
Do the same adding the line "Requery" or replace for "Move 0" and all works fine
Is this a bug in LEADTOOLS 14 or what can I do ??
Thank you
|
|
|
|
|
Report
|
|
|
|
12-17-2006, 9:56
|
Bashar

Joined on 08-27-2003
Posts 1,057
|
Re: I need update images without Requery
|
 
 
|
|
|
You are right. I get the same behavior. I have reported
this to development for investigation. I will post back as soon
as I hear from them. Until then, refer to this issue using this
ref#: 5274AMN.
Bashar Abdulqaiyume LEAD Technologies, Inc.
|
|
|
|
|
Report
|
|
|
|
05-08-2007, 8:26
|
Maen Hasan

Joined on 08-05-2004
Posts 1,874
|
Re: I need update images without Requery
|
 
 
|
|
|
Hello,
Regarding incident number 5274AMN, our engineers marked this incident as fixed. To get the latest LEADTOOLS v14.5 patch, please send your LEADTOOLS v14.5 serial number to support@leadtools.com to get the latest patch.
Thanks, Maen Badwan LEADTOOLS Technical Support
|
|
|
|
|
Report
|
|
|
|
|
LEAD Support Fo... » Developer » Database » Re: I need update images without Requery
|
|
Copyright LEAD Technologies, Inc. 2008
