Search found 62 matches

by Peterg
Thu May 22, 2008 3:58 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Editors
Replies: 19
Views: 4497

Just want to say thanks to all of you for your input and recommendations.

Great work guys

Peter
by Peterg
Thu May 22, 2008 8:46 am
Forum: FiveWin for Harbour/xHarbour
Topic: Editors
Replies: 19
Views: 4497

Antonio
I cannot get the file from rapidshare. I keep getting different errors

Can you email it to me please peter@plsoft.co.uk

thanks
by Peterg
Wed May 21, 2008 3:57 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Editors
Replies: 19
Views: 4497

UEStudio looks good. Have you created any wordfiles for prg files that you could share

Thanks
Peter
by Peterg
Wed May 21, 2008 2:50 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Editors
Replies: 19
Views: 4497

Editors

Hi all

What does everybody use as a prg editor. I am still using brief as I cannot find anything better

Thanks
Peter
by Peterg
Wed May 21, 2008 2:24 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Any clever coders out there
Replies: 22
Views: 4804

Hi all I have recoded the function using arrays to store the seek definition and then a series of IF/THEN conditions to test each of the seek definitions prior to actually seeking in the table. This has resulted in an 8 fold increase in speed and is now as fast in sql as it was in dbf (and of course...
by Peterg
Tue May 20, 2008 4:08 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Any clever coders out there
Replies: 22
Views: 4804

I have created the following stored procedure which works but is just as slow as 32 seeks Any ideas Use iwscompa go IF OBJECT_ID ('usp_find_price') IS NOT NULL DROP PROCEDURE usp_find_price go CREATE PROCEDURE usp_find_price @mSite numeric(2), @mCustType varchar(10), @mCustNbr varchar(10), @mUniqNbr...
by Peterg
Tue May 20, 2008 1:42 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Any clever coders out there
Replies: 22
Views: 4804

The result should only return one record which should be the best match
by Peterg
Tue May 20, 2008 1:15 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Any clever coders out there
Replies: 22
Views: 4804

James
Possibly but i am not that good at sql. Any ideas wher eot look

Thanks
Peter
by Peterg
Tue May 20, 2008 12:24 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Any clever coders out there
Replies: 22
Views: 4804

Antonio
This will result in 64 seperate or statements. Do you think this will be faster

Peter
by Peterg
Tue May 20, 2008 11:20 am
Forum: FiveWin for Harbour/xHarbour
Topic: Any clever coders out there
Replies: 22
Views: 4804

I am not sure where to start but here goes variable declarations mSiteID = 1 mCustacc = "ABC123" mUniqnbr = "0000000001" mCustType = "EXTERNAL" mContainer = "1100WB" mWaste = "GENERAL" mDisposer = "XYZ987" mDate = DATE() select * from skipp...
by Peterg
Tue May 20, 2008 8:00 am
Forum: FiveWin for Harbour/xHarbour
Topic: Any clever coders out there
Replies: 22
Views: 4804

Hi all Firstly how do I upload a sample prg and dbf for testing? The price file could be very large > 150K records and could be updated by any number of users during the course of the day so cerating an array is probably not possible. A price can exist for the following site (internal identifier) cu...
by Peterg
Fri May 16, 2008 2:19 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Any clever coders out there
Replies: 22
Views: 4804

Any clever coders out there

Hi all I have a function which seeks for a price in a table which can have upto 64 different combinations. As a result of this there are 64 seeks per find which is quite fast in dbf but horribly slow in sql. Can anyone suggest a better way for writting this function. I will pay for any good ideas Th...
by Peterg
Thu Apr 24, 2008 1:14 pm
Forum: FiveWin for Harbour/xHarbour
Topic: timage
Replies: 36
Views: 4412

Antonio

Do you have a sample buildx where more than one prg file is compiled

Thanks
by Peterg
Thu Apr 24, 2008 1:06 pm
Forum: FiveWin for Harbour/xHarbour
Topic: timage
Replies: 36
Views: 4412

Antonio
Thanks
I will try a build on one of my applications and let you know how it goes

Peter
by Peterg
Thu Apr 24, 2008 12:42 pm
Forum: FiveWin for Harbour/xHarbour
Topic: timage
Replies: 36
Views: 4412

Yes please