Forum Discussion

Qrew Cadet

3 years ago

Formula Query Error - The way this formula is built will take too long to process.

Is URLEncode() not functional inside of a Formula Query? When I attempt to use it, I receive this error message. Here is my formula: Size(GetRecords("{52.EX." & URLEncode([Job]) & "}AND{27...

formula queries

JonFroderberg

Qrew Cadet

Hi Mike-
Yes, this is a fairly busy table. 80K+ records and 244 fields.

------------------------------
Jon Froderberg
PRIME Developer
Harder Mechanical Contractors
https://www.harder.com
Portland, OR
801.946.0576
------------------------------

MikeTamoush

Qrew Commander

3 years ago

I'd be willing to be it is the size of the table. I have not found a work around or a way to get it to query my tables that big. Please post back if you come up with a solution!

------------------------------
Mike Tamoush
------------------------------