Nadav Caridi
- Actividad total 163
- Última actividad
- Miembro desde
- Siguiendo 0 usuarios
- Lo siguen 0 usuarios
- Votos 5
- Suscripciones 62
Comentarios
Actividad reciente de Nadav Caridi-
Hi, Not sure if it's in the backlog . still very interested. Thank you !
-
Hi , Yes if you can write a query for this scenario , why not ?
-
Comentario oficial 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 !
-
Comentario oficial Hi You can use dynamic syntax with SQL SELECT ISNUMERIC(yourDyanmicSyntaxFieldHere);
-
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...
-
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
-
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...
-
Hi, just concat the columns in your sql
-
Hi Kate, I've only ever tried populating a single value. Can you elaborate what you're trying to do ?
-
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