FiveTech Software tech support forums

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

Great work guys

Peter

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

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

Thanks
Peter

Hi all

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

Thanks
Peter

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

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

The result should only return one record which should be the best match

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

Thanks
Peter

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

Peter

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

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

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

Antonio

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

Thanks

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

Peter

Yes please