Search results for query: *

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

do you already try to install jet4sp8 (service pack for jet engine 4) ? ... download it from microsoft site (http://www.microsoft.com/downloads/details.aspx?FamilyID=2deddec4-350e-4cd0-a12a-d7f70a153156&displaylang=en).

oke, thanks ... i think it becuase dereferencing and macros

f1 = fopen("mail.txt") f2 = fcreate("newmail.txt") do while not feof(f1) b = fread(f1, 1) if not inlist(b, chr(13), chr(10), <added as needed>) = fwrite(f2, b) endif enddo =fclose(f1) =fclose(f2)

Oops ... yes, the correct statement is "REPORT FORM myreport.frx", but it is my typo-mistake :) sorry about that. the real issue is that statement "REPORT FORM myreport.frx" is working correctly when it is executed inside FOXPROX.EXE, but if I build the statement into working standalone...

Hi all, since 1997, i used foxpro 2.6 dos to create several small program for my company. Usually i use "FOXPROX myprog.app" to start my program, and it's doing fine. now, i'm trying to compile myprog.app into full standalone extended executable file using Distribution Kit, because it much...