Loading a VarBytes field into a stream
Hi,
I have a query that returns a field as a VarBytes field from a MS SQL database.
I am using dbGo ADO components to access this database, but I am having a
problem getting access to the data in the field. It's Turbo Delphi 2006, BTW.
If it had been a TMemoField, I could have used the ADOQuery.CreateBlobStream,
but not in this case - it generates a typecast error.
So, how should I do this?
Thanks,
Andy
.
Relevant Pages
- Re: Loading a VarBytes field into a stream
... Andy Stephenson wrote: ... I have a query that returns a field as a VarBytes field from a MS SQL database. ...
(borland.public.delphi.database.ado) - Re: SQL vs. Access
... I can't say I know the rules in depth, but typically if you are using /linked/ tables in Access and you're not using a "pass-through" type query, then Access could be reading all the data it "thinks" is necessary to do the necessary joining/filtering, which may require a lot of data to pass between our SQL database and Access, which could I assume lead to behaviour which either looks like a hang or is a hang. ... Security. ... plain text logon/password information into your Word file or a .odc file. ...
(microsoft.public.word.mailmerge.fields) - Re: Autonumber needed in form when new record opens
... > frustrating. ... >>> SQL database with Access Project ... can you update records in it? ... >> query? ...
(microsoft.public.access.modulesdaovba) - Re: Autonumber needed in form when new record opens
... >> SQL database with Access Project ... > query, can you update records in that query? ... > Dirk Goldgar, MS Access MVP ...
(microsoft.public.access.modulesdaovba) - sql query for excel column values
... I have a spreadsheet that I receive daily. ... 50-1000 values in column A that I need to query an sql database for. ... A2, do the query, return the results to a new workbook, and continue down the ... I set it up so that it queries each cell value until the end of the data? ...
(microsoft.public.excel.programming) |
|
