Using the BULK INSERT requires certain permissions, how do you set permissions in SQL for a user to read in csv files in a stored procedure and also from the SQL Studio itself?
Type: Posts; User: Sam Neuner
Read CSV in SQL
Using the BULK INSERT requires certain permissions, how do you set permissions in SQL for a user to read in csv files in a stored procedure and also from the SQL Studio itself?
Re: WebApp Setup
Looks like it. Will test it.
Re: WebApp Setup
Something very strange (BTW, this is on a customer's site). We have 19.1 and 20.1 both using the same Test Database in MSSQL. The 19.1 has two managed connections, one using trusted connection and...
Re: WebGrid Row Requiring Column Entry When No Changes
Sorry wrong post, please ignore! (This was for the WebPrompt problem that I have solved).
Re: cWebPrompt Constraint Problem
Send FindFromTop did the trick!
Re: WebGrid Row Requiring Column Entry When No Changes
Object oCARSTATWebLookup is a cWebModalDialog
Set piColumnCount to 12
Set psCaption to "Load Tracking Lookup"
Set piWidth to 700
Set piHeight to 400
{ WebProperty=ServerSession...
Re: cWebPrompt Constraint Problem
Reading the property is not the problem. During debugging the constraint is getting the correct value, it is just not displaying any rows!
WebApp Setup
Setting up a new WebApp (20.1) and connecting to SQL Server database. Getting the following error:
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed. The login is from an...
Re: cWebPrompt Constraint Problem
DD:
Procedure OnConstrain
String sOption sDate
Date dToday dLastWeek
Sysdate dToday
Move (dToday - 7) to dLastweek
Forward Send...
cWebPrompt Constraint Problem
I have a Web Prompt with constraints that can be changed with a Web Combo. The Model Dialog has a Web Property that stores the combo selection that is defaulted to one of the combo items. The...
WebGrid Row Requiring Column Entry When No Changes
A WebGrid with a "Required" column will not let you exit the row even when no changes have been made. Even after you click "Clear/Add" on the Toolbar. What is the problem?
Re: "Invalid Column Name"
Just to clarify, using DF 19.1. The windows event log states: "Failed to start child process WebApp.exe". Under "Details" it states: "The system cannot find the file specified ("WebApp.exe").
Re: "Invalid Column Name"
Another issue, when we try to run the WebApp outside the debugger using "Open Application URL" it will not run or gives an error 5122. I think it must be a permissions issue but need some assistance...
Re: "Invalid Column Name"
Resolved the issue. The setup at the customer site where we are developing the WebApp has to have the AppHtml, Data, and Programs on the developers local machine to run the WebApp on the localhost. ...
Re: "Invalid Column Name"
Will try the Alt +G.
Re: "Invalid Column Name"
No SQL filter. Only seems to happen when a Lookup is attached to the DD. Deleted the original Lookup and created a new one with the Wizard. Still get the error.
Re: "Invalid Column Name"
Cleared browser cache and the table CCH.
Re: "Invalid Column Name"
It is on a customer's system. I will get a copy and post it.
"Invalid Column Name"
DF 20.1. Have a very strange error! When loading the WebApp it generates an error referencing a column name that is no where to be found in the code! That column name was renamed but the error is...
Re: Web Prompt List
My question would be, how are you suppose to do Lookups in a drilldown style? I know you can set the button in the Webform and send Popup, but I mean what is DAC's thinking here?
Re: Web Prompt List
Thanks Peter did not know there were differences like this in the style. Any others of significance that you are aware of?
Re: Web Prompt List
DrilllDown.
Web Prompt List
DF 2019. What would cause a Web Prompt List assigned in the DD to the column, but not the main table, to not display the lookup button and not Popup the List? The peUpdateMode is set to...
Re: cWebList Column Header Height
Set psTheme to "Df_Windows_Like"