Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kyriakos70

  1. kyriakos70

    using tables php navigation question

    Hello, I am using in a webpage tables and include php function to create a webpage without frames, I want to ask how can I navigate with a navigation bar, when using frames I was target mainframe and the html file wanted to display, now what I can enter in the navigation button to change the...
  2. kyriakos70

    directx window dimensions

    Hello, I have a windowd mode directx window, I load a bmp image, I want to set the dimensions of the window to mach the dimensions of the image, where do I set this dimensions? Thank you Kyriakos
  3. kyriakos70

    quick reports print jpg file

    I try load the jpg from a database. Kyriakos
  4. kyriakos70

    quick reports print jpg file

    I have a question how can I print a jpg file through the qrdbimage quick report, it only supports bmp. Thank you kyriakos
  5. kyriakos70

    top 5 like statment

    I found this is it correct? I mean there must be something else like between etc., can you give me an example about my query, more simple? USE AdventureWorks2008R2; GO WITH OrderedOrders AS ( SELECT SalesOrderID, OrderDate, ROW_NUMBER() OVER (ORDER BY OrderDate) AS 'RowNumber' FROM...
  6. kyriakos70

    top 5 like statment

    Hello, I want a statment to work like top 5 but not only for the first records but for a page of records eg from record 5 to 10, I have used this but gave me an error : 'SELECT TOP 5 * FROM scan WHERE id NOT IN (SELECT TOP 4 * id FROM scan Where id like (:aaaid))' also would like to have a...
  7. kyriakos70

    adoquery error out of memory 2

    Hello, I am still getting the out of memory error, even I have used the adoquery with this sql string : select * from scan inner join Table1 on scan.id=Table1.id where scan.id like '+quotedstr(edit1.text) and have in the edit box the value of the primary key of the Table1 (master table), it...
  8. kyriakos70

    sql database ado out of memory

    Hello, I am still getting the out of memory error, even I have used the adoquery with this sql string : select * from scan inner join Table1 on scan.id=Table1.id where scan.id like '+quotedstr(edit1.text) and have in the edit box the value of the primary key of the Table1 (master table), it...
  9. kyriakos70

    sql database ado out of memory

    I still get the out of memory error after I navigate to 4-5 records, I have manually created the relationship with an adoquery (to move with the master and put it in a onclick event of a button record), my question is is there a buffer which holds previous records in memory and needs to be...
  10. kyriakos70

    adoquery

    And a last question, how can I add an edit.text as a value in an sql string? eg 'select * from scan inner join Table1 on scan.id_2=Table1.id Where scan.id_2="edit1.text"' I get an error invalid column name. thank you Kyriakos
  11. kyriakos70

    sql database ado out of memory

    I am connecting the primary key of the master and the foreign key of the detail table, yes Djangman that is what I want to do, but I found another thing the detail table which has a primary kay a foreign key and a blob field is 500 MB , has too many pictures in it has to do something with it...
  12. kyriakos70

    question about 3rd party component

    here is the code if Image1.Picture.Bitmap.Handle <> 0 then Image1.Picture.Bitmap.ReleaseHandle; Image1.Picture.Bitmap.Handle := VSTwain1.GetCurrentImageAsHBitmap; I want to save the current image as jpg in the sql table, how can I do it? Kyriakos
  13. kyriakos70

    question about 3rd party component

    Hello, I have a question about a component named vintasofttwain activex, my question is how can I aquire an image and save it as jpg. Any help anyone who uses it. Thank you Kyriakos
  14. kyriakos70

    sql database ado out of memory

    Well, it happens when I try to establish the relationship between the two tables through the 2 ado datasets, when there is no relationship the dataset becomes active but when I try to create the relationship with the master's table ado dataset I get an error "out of memory". I have no code...
  15. kyriakos70

    sql database ado out of memory

    Here is the details of the error, (it raises when I try to make a relationship between the master Table and the Detail which has the blob field, through the two ado datasets) + $13[527E409B]{adortl100.bpl} ADODB.ADODB.TCustomADODataSet.InternalSetSort (Line 5630, "adodb.pas" + 1) + $13 +...

Part and Inventory Search

Back
Top