Creating an sql query string based on WHERE statement

[Shuki Birshan]

Hi,

I have the need to write SQL query as string.
until now, I always used the build in Where firefly's business process. 
it is much more convenient for me.
especially when writing a query that takes several tables and variables.
but I have a need to run a query without the bp.

I was wondering if the is an option to continue create the where like I want, and then translate it to an SQL string query statement to use in the code ?

Thanks,
Shuki.

[Lawrence Fisher]

Add the sql as a string, say sqlString, you can also use string.Format.

Then use an sqlEntity.

I think there are examples on the site. If not I can show you 

Sent from my iPhone

Lawrence

On 12 Mar 2025, at 08:58, Shuki Birshan <subirs...@gmail.com> wrote:

Hi,

--
You received this message because you are subscribed to the Google Groups "Migrated By Firefly" group.
To unsubscribe from this group and stop receiving emails from it, send an email to migrated-by-fir...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/migrated-by-firefly/edf8b119-0bea-4437-aecb-7bf1bb89cd72n%40googlegroups.com.

[Noam Honig]

Check out:
https://doc.fireflymigration.com/easysql-writing-better-sql.html
https://doc.fireflymigration.com/accessing-the-database-directly.html

Noam Honig  

Founder & CEO

www.fireflymigration.com

To view this discussion visit https://groups.google.com/d/msgid/migrated-by-firefly/B17A518D-FEC4-41ED-8F51-C12B9CA90D88%40gmail.com.