Nadav Caridi

Hi, Not sure if it's in the backlog . still very interested. Thank you !  

• View comment
• March 12, 2021 07:44
• 0 votes

Hi , Yes if you can write a query for this scenario , why not ? 

• View comment
• March 05, 2021 00:40
• 0 votes

Hi ,  recent versions of B1up supports dynamic syntax within dynamic code; so you can just call it like you'll call it within a macro . e.g.  string myVar=dymaicSyntaxHere;   Good Luck !   

• View comment
• February 09, 2021 23:35
• 0 votes
• Official comment

Hi  You can use dynamic syntax with SQL  SELECT ISNUMERIC(yourDyanmicSyntaxFieldHere);

• View comment
• February 09, 2021 23:33
• 0 votes
• Official comment

The way I see it With line loop you query the contents of each line. You can call sql statements of all sorts but you already hold most of the rdr1 data in the table so why do it? Other than that w...

• View comment
• January 29, 2021 14:42
• 0 votes

I use SBO so I'm not sure about the differences .  wouldn't this work when you loop through ? SELECT CASE WHEN ($[$38.40.0]='O')THEN (SELECT 'RES' FROM DUMMY ) END FROM Dummy        

• View comment
• January 29, 2021 13:08
• 0 votes

Try using some combination of stuff maybe. You can look here for some examples or just try ti Google it https://www.mssqltips.com/sqlservertip/2914/rolling-up-multiple-rows-into-a-single-row-and-c...

• View comment
• January 24, 2021 17:15
• 0 votes

Hi, just concat the columns in your sql

• View comment
• January 24, 2021 15:39
• 0 votes

Hi Kate, I've only ever tried populating a single value. Can you elaborate what you're trying to do ?   

• View comment
• January 24, 2021 15:27
• 0 votes

Hi I'd do that with a line loop combined with dynamic code. If you're not familiar with dynamic code you might be able to achieve that with activate + ui clicks, set values etc etc Good luck

• View comment
• August 24, 2020 22:35
• 0 votes