Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm pulling data from a SQL server db via OLEDB. In one table some fields have a /-sign (slash) in it. Now i suspect that while getting the data into QV those field values are truncated at the slashes. Current statement is simply: SQL SELECT FROM blah.dbo.blah. Any advice? Thanks, Sander
One suggest is, in select sentence can use functions for SQL, in this case, you can be use function replace().
select a, b, c from table
select a, replace(b,'/','x') as b_r, c from table
This functions works for the execution run in Server, not in QV.
im wait this stuff works for you, regads.
Saludos desde Mexico
One suggest is, in select sentence can use functions for SQL, in this case, you can be use function replace().
select a, b, c from table
select a, replace(b,'/','x') as b_r, c from table
This functions works for the execution run in Server, not in QV.
im wait this stuff works for you, regads.
Saludos desde Mexico
Hi BeristarDJ, your tip to use the replace function helped me to 'restore' the value I need in this case. Still looking into a way to fully prevent the truncating at the slash in this setup. But fine for now. Regards, Sander