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

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

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 skippric
where site_id = mSiteID and sp_custno ...

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

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

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