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!

Register Log in
  • Congratulations Rhinorhino 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 sipos

  1. sipos

    Aggregate Field Type String

    Hi, ryanEk thanks for ss 2k5's code, but yes, i will use the code on ss 2k, so your code will not work. But ... again ... many thanks :) and to gmmastros thanks for the links, it helps a lot.
  2. sipos

    Aggregate Field Type String

    Hi, these days i'm trying to build a group-by-SQL-Query to aggregate a string This is an example of dataset i have Dept Name Jenis Qty ======================= A 1 X 2 A 2 Y...
  3. sipos

    Do you know a Single Query To Get Item Count?

    BTW, i just check in the help online for Foxpro 2.6 DOS and i cannot find the explanation that word "distinct" can be used inside statement COUNT() in select query. this is a very brand new to me ...
  4. sipos

    Do you know a Single Query To Get Item Count?

    oopps ... i'm sorry ... i don't see the "distinct" word inside COUNT() statement which is given by tamargranor yes ... it is working like magic. The word "distinct" is the magic word for COUNT to distinct the code. i never know that statement "DISTINCT" can be used inside COUNT statement ...
  5. sipos

    Do you know a Single Query To Get Item Count?

    yes tamargranor, thanks for your query, but do you know a single query to create same exact result? or is the double query is the best query we can get?
  6. sipos

    How to make a field in SELECT have necessary size?

    or create the result table first ==================================== for example create cursor table_final; (; field N(15,3); ) select field1 as field from table1 into dbf x sele table_final appe from x select field2 as field from table2 into dbf x sele table_final appe from x dele...
  7. sipos

    Do you know a Single Query To Get Item Count?

    hello jrbbldr, cricket and tamargranor ... thanks for your responds. my resultset is correct 001 = 2 (not 3) because in trans_id=001 there are 2 items (A and B). In quantity, yes A = 2 and B = 1, so the total is 3, but as items ... A=1 and B=1, so the total item is 2. that's why i'm using 2...
  8. sipos

    Do you know a Single Query To Get Item Count?

    hello everyone, i'm using FPD26 and i have a table like this (table_01) trans_id code 0001 A 0001 B 0001 A 0002 C 0002 A 0002 B and i want to have a result like this (table_02) trans_id tot_item...
  9. sipos

    Connected using FPSQL.PLB

    you should called a resident program named DBNMPIPE.EXE that has been given to you by every SQL installer below v2000 ... BEFORE you use your DB-Libray interface program. DBNMPIPE.EXE hasnot changed since SQL v.7, so SQL 2000 didnot give this program in their installer. NOTES ... Even when...
  10. sipos

    Connected using FPSQL.PLB

    sorry ... i'm using DOS in WinXP.
  11. sipos

    Connected using FPSQL.PLB

    Finally, i found a word on the sample in SQL Samples for DB-Library. Actually, before we can use DB-Library for MS-DOS, we need to resident a program. The program is DBNMPIPE.EXE. and then, i search the file, and i cannot found it anywhere (in SQL installation package, in my hardisk). So I...
  12. sipos

    Connected using FPSQL.PLB

    I don't think that's the problem ... because the Fox 26 LCK package only give the .PLB. There is no other program. But supposed, if what you say is correct, then LCK should say something about a resident program to be called before calling .PLB. But i don't find it in the documentation. Or do i...
  13. sipos

    Problem with Overlapping Printed-Character Under 2K/XP

    to ezopaci: Aahhh ... why i don't think about it :). But because it is weekend, i cannot try it till monday. Thanks anyway to remind me on that stuff [ODSR and OCTS].
  14. sipos

    Connected using FPSQL.PLB

    Hi, i was just trying to use FPD26 Connectivity Kit (FPSQL.PLB for sure). I was trying connecting to SQL Server 2000. But the FPSQL told that there was an error happened when it tried to connect to the server ... This is the error message: DB-Library error 10040: DB-Library network...
  15. sipos

    Problem with Overlapping Printed-Character Under 2K/XP

    Hi all, I created a program using FP2.6 DOS and has tried to run it under WinXP. This program will output to COMx printer and usually print a two or more pages. I got a problem here. In WinXP and Win2K, the printed-character will be printed overlap each other after printing two pages or more...
See more

Part and Inventory Search

Back
Top