Trim error

netscon · **Posted:** Tue Feb 15, 2005 1:35 pm

hi, Im trying to trim a variable from a Visual Fox database. Im using the ALLTRIM function but its not working. Any hint? Here is the log details: Im interested in the @TRIM_SERIE variable (ALLTRIM(num_serie) AS TRIM_SERIE Feb 15 13:36:00.67: [1] START Feb 15 13:36:00.67: [42] DB Connect Feb 15 13:36:00.67: ConnectString: DSN=CONSULTA Feb 15 13:36:00.68: SQL Error State: 01000 Native Error Code: 0 ODBC Error: [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). Feb 15 13:36:00.68: SQL Error State: HYC00 Native Error Code: 0 ODBC Error: [Microsoft][ODBC Visual FoxPro Driver]Driver not capable Feb 15 13:36:00.70: [11] SQL Begin Transaction Feb 15 13:36:00.70: [12] SQL Statement Feb 15 13:36:00.70: <----- BEGIN -----> SELECT corralon, infraccion, tipo, marca, modelo, fecha_entr, ALLTRIM(placas) AS TRIM_PLACAS, tipoauto, adeudo, corralnom, cproced, ALLTRIM(num_serie) AS TRIM_SERIE FROM infotel.dbf <----- END -----> Feb 15 13:36:00.71: [15] SQL Fetch Feb 15 13:36:00.71: Setting global variable '@CORRALON' to '05' Feb 15 13:36:00.71: Setting global variable '@INFRACCION' to '44611' Feb 15 13:36:00.71: Setting global variable '@TIPO' to '02' Feb 15 13:36:00.71: Setting global variable '@MARCA' to '002' Feb 15 13:36:00.71: Setting global variable '@MODELO' to '1981' Feb 15 13:36:00.71: Setting global variable '@FECHA_ENTR' to '1992-04-29' Feb 15 13:36:00.71: Setting global variable '@TRIM_PLACAS' to '902YMD ' Feb 15 13:36:00.71: Setting global variable '@TIPOAUTO' to 'PICK-UP Ford 1981 ' Feb 15 13:36:00.71: Setting global variable '@ADEUDO' to '165299' Feb 15 13:36:00.71: Setting global variable '@CORRALNOM' to 'CERESO ' Feb 15 13:36:00.71: Setting global variable '@CPROCED' to '01' Feb 15 13:36:00.71: Setting global variable '@TRIM_SERIE' to 'JC4UA2222B0535617 ' Feb 15 13:36:00.73: [78] Run Flowchart Feb 15 13:36:00.73: Flowchart: 'ExtrerCincoDigitos' Feb 15 13:36:00.73: ConsulSerie==> ExtrerCincoDigitos Feb 15 13:36:00.73: [1] START Feb 15 13:36:00.73: [6] Math Feb 15 13:36:00.73: @LONG_SERIE = LENGTH (@TRIM_SERIE) Feb 15 13:36:00.73: @LONG_SERIE = LENGTH (JC4UA2222B0535617 ) Feb 15 13:36:00.73: Setting global variable '@LONG_SERIE' to '20' Feb 15 13:36:00.75: [8] Math Feb 15 13:36:00.75: @START_POS = @LONG_SERIE - 4 Feb 15 13:36:00.75: @START_POS = (integer):20 - (integer):4 Feb 15 13:36:00.75: Setting global variable '@START_POS' to '16' Feb 15 13:36:00.75: [7] Math Feb 15 13:36:00.75: @CINCO_NUM_SER = substr (@TRIM_SERIE, @START_POS, 5) Feb 15 13:36:00.75: @CINCO_NUM_SER = substr (JC4UA2222B0535617 , 16, 5) Feb 15 13:36:00.75: (integer): 5 Feb 15 13:36:00.75: Setting global variable '@CINCO_NUM_SER' to '17 ' Feb 15 13:36:00.75: [2] FINISH Feb 15 13:36:00.75: ConsulSerie<==ExtrerCincoDigitos Feb 15 13:36:00.76: [17] Compare Feb 15 13:36:00.76: @MISERIE = @CINCO_NUM_SER? Feb 15 13:36:00.76: (integer):35617 = (string):17 ? Feb 15 13:36:00.76: FALSE

netscon · **Posted:** Tue Feb 15, 2005 1:47 pm

Sorry, I forgot to say that I only need the last 5 digits of @TRIM_SERIE thats why im using ConsulSerie flowchart (Feb 15 13:36:00.73:)... to extract last 5 digits The problem is that num_serie field of the database is not always the same lenght. Usualy num_serie field has a lenght of 17 plus 3 blank spaces and I have to take the last 5 digits out of the 17 characters, but sometimes num_serie is populated with a string of 13 + 7 blank spaces and in that case I have to take the last 5 digits out of the 13 characters. As a sumary: I have to take the last 5 digits of the populated num_serie field regardless of the blank spaces.

Chris · **Posted:** Tue Feb 15, 2005 3:15 pm

If the ODBC driver doesn't do what you need it to, you will have to use TeleFlow to "fix" your variables after retrieving them from the database. The easiest thing to do is add the FindAndRemoveString template flowchart to your application, and pass in the variables you retrieve from the database, and have it remove @SPACE (this is a TeleFlow system variable containing a single space character) from the string. To add the template, go to your TAP screen, and go to the "Templates" tab in the "Steps Toolbar". Click FindAndRemoveString, and drop it into your application. After you remove the spaces, you can continue to copy the 5 characters out of the variable as you are doing now.

netscon · **Posted:** Tue Feb 15, 2005 5:48 pm

thanks Chris.... it works ok