Recent content by sipos

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.

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...

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 ...

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 ...

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?

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...

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...

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...

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...

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

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...

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...

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].

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...

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...