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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Daniele71SV

    Delphi 7 + Crystal Report 9 Dev. Edition

    I have installed Crystal Report 9.2.0 from CD. VCL CRPE from Crystal Decision Download area: only work with version 9.2.2! So I downloaded service pack for CR9 and it becomes 9.2.3! VCL CRPE doesn't function!!! How can I get all these work? where is version 9.2.2 of CR9 OR where is VCL CRPE for...
  2. Daniele71SV

    AS 400 linked server openquery and member specification

    OK, it doesn't work anyway! 1. AFERDEF0 and MFFFARF0 are in the same database; if I do this: EXEC sp_tables_ex 'AS400' I get all the tables and views in AS400 linked server, and there are both AFERDEF0 and MFFFARF0. 2. I've tried SELECT * FROM EPFILC1.AFERDEF0.ANNO02 and SELECT * FROM...
  3. Daniele71SV

    AS 400 linked server openquery and member specification

    This query is OK, I mean it returns all rows from the table: SELECT * FROM OPENQUERY(AS400, 'SELECT * FROM EPFILC1.MFFFARF0 WHERE FRNDO$ = 51504') This one returns no rows, even if I known there are records in the table: SELECT * FROM OPENQUERY(AS400, 'SELECT * FROM EPFILC1.AFERDEF0') I...
  4. Daniele71SV

    AS 400 linked server openquery and member specification

    I've succefully set up a linked server to an as 400. I can do such thing as retrieving all record from tables through the OPENQUERY statement. However, when I query some table (that I need, NOW) the result set contains zero record. I known that it's a problem of specifying the MEMBER of that...

Part and Inventory Search

Back
Top