0

We convert DBF table to ADT. While running the code after conversion, an error pops up in numeric datatype in columns. If we manually change the datatype to money it will work. I want to automate this stored procedure to change the table column datatype and find out if there is sp_ModifyFieldProperty in procedure.

But nothing happened and got prompt with error in advantage data architect v.10

poQuery: Error 7200: AQE Error: State=HY000; NativeError = 5254; ...etc

Please help with any info on this topic

EXECUTE PROCEDURE sp_ModifyFieldProperty( ‘fdcku00’, ‘FDC_WID’, money, ‘FIELD_CAN_BE_NULL’,‘FALSE’, ‘RETURN_ERROR’,NULL );

gopi.jtech
  • 11
  • 5
  • Please post the *full* error message. – Jens Mühlenhoff Jul 12 '19 at 09:11
  • poQuery: Error 7200: AQE Error: State = HY000; NativeError = 5154; [iAnywhere Solutions][Advantage SQL][ASA] Error 5154: Execution of the stored procedure failed. Error 7200: AQE Error: State = S0000; NativeError = 2121; [iAnywhere Solutions][Advantage SQL Engine]Column not found: ‘fdcku00’ -- Location of error in the SQL statement is: 43 (line: 2 column: 1) – gopi.jtech Jul 12 '19 at 09:27
  • The error message is a bit odd, since you are passing 'fdcku00' as the table name to the stored procedure. Anyway ADS is complaining about the tablename and / or column name argument (the first two arguments). Check that you are actually passing the right table and column name to the SP. – Jens Mühlenhoff Jul 12 '19 at 12:41
  • 1
    Oh and you could also use the `ALTER TABLE … ALTER COLUMN` syntax as an alternative. – Jens Mühlenhoff Jul 12 '19 at 12:42
  • Syntax sp_ModifyFieldProperty( TableName,CHARACTER,200, FieldName,CHARACTER,200, Property,CHARACTER,200, Value,MEMO, ValidationOption,CHARACTER,25, FailTable,CHARACTER,515 ) This was the code I followed from the web (http://devzone.advantagedatabase.com/dz/webhelp/Advantage9.0/adssql/sp_modifyfieldproperty.htm) .The first parameter is TableName and second one is Column. – gopi.jtech Jul 13 '19 at 03:12
  • ok thank you @Jens Mühlenhoff Alter works as procedure. Thank you very much. – gopi.jtech Jul 13 '19 at 03:20

0 Answers0