Home > Back-end >  Help: Delphi statements modify Sql Server custom function has no response for help
Help: Delphi statements modify Sql Server custom function has no response for help

Time:10-06

There was a custom function in SQL Server needs to be modified,
In Delphi use statement which modifies the Alter the Function or delete the Function drop Function and recreate the CREATE

Function can perform some error in the program, enterprise manager review and check the grammar shows that the modified, there is no mistake, but the program

Involved in the function call where no response is not an error,
But the function in the enterprise manager to delete, and recreated after (with Delphi statements to create exactly the same) program can properly adjust

Use this function,
Using the ADOConnEction in Delphi. The Execute (' function changing statement ") modify the custom function,
For other reasons the function required to use the modified Delphi statements, rather than directly from the enterprise manager changes, the great god, please give directions, problems

Where is it?
!!!!!!!!!

CodePudding user response:

No one ever use a custom function?

CodePudding user response:

How do you separate the delete function and create function to perform?
I always use, so it's all done in Delphi, without any problems

CodePudding user response:

How to separate? I am the first remove, and then create such: ADOConnEction. Execute (' drop function function ') then,
ADOConnEction. Execute (' the CREATE function function ')
This is not handled separately? Give advice or comments please!!!!!

CodePudding user response:

This did not know,
I always use ADOQuery ExecSQL

CodePudding user response:

Function of the noun is in Chinese? Add [and] have a try?
Will use adoquery error?

CodePudding user response:

Have may be user or permission problems, such as you use Delphi built out of that some functions, others do not have permission to perform, and enterprise manager or you inadvertently quietly did this authorization operation?
  • Related