I define the Queries as BDE objects, and run them in code like:
qryName.close
qryName.open
qryName.requestlive := true
qryName.Insert
'filling code for each field to be filled
qryName.Post
This works allright, but for every record some logic is applied and overall performance is slow. However...
Hello,
I have some ORACLE queries I want to run. When I do this from ORACLE SQL Developer, they run OK, but when I run them from Delphi it takes far too long. This is because I'm talking about millions of records, so performance is a real issue here. However, the whole process should be...
Thanks! The code seems to work allright for me when I use a select statement, insert/update/delete statements don't work but I found out this probably is not because the code does not work but because I don't have the appropriate rights on the database I'm working on. I think after I got those...
Hi there,
I want to run a batch of letters from Word XP, the adressee's are in an Access XP table. I saw that you can define bookmarks in a Word document, I am wondering how to link those bookmarks to the table fields. Does anyone know how to do this ? (I want to use VB-code).
any help will be...
Hi there,
I want to use a TQuery object to store data in an Oracle database. I want to insert form-values in the database by setting the querie's SQL-properties about like this: INSERT INTO TABLENAME(COLUMNNAME) VALUES(formvalue)
Does anyone know how to get these formvalues in the...
Hi K5tm.
Thanks for the input.
The situation is like this:
I have an XML sheet with many tags, nodes, subnodes and so on. I use XSLT to get some of the information in ASCII, and in one row of ASCII text I have to write some header info and some repeating info from repeating tags. But the header...
Hi there,
I have a simple question. I want to store some info from a certain Tag in an XML file. I want to do this within a for-each loop in an XSLT formatting sheet. I use a variable to do this. The problem is: when I leave the loop the value of the variable is gone. Is there any way to store...
Hi There,
I tried every suggestion, unfortunately I did not succeed. Now I understand why, I seem to have missed a quite simple point. In the batch file I did not include any reference to the path of the msxls executable or the output file. I did not think this was necessary because the...
Hi there,
I call a batch using ShellExecute using the next lines of code:
if ShellExecute(0, nil, PChar('d:\RNH\zd.bat'), nil, nil, SW_NORMAL) <= 32 then
begin
label4.caption := 'error';
end;
When the batch is tested from the command prompt or from windows it does what it should. When I...
Hi there,
I have written an .XSLT stylesheet meant to transform a great number of .XML files. I included a reference to the .XSLT stylesheet in the .XML files and the output is OK. Now I want to automate the process of transforming the .XML files by running a batch. I use Oxygen as...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.