Importing field into grid issue

[Al Buchholz]

Re: Importing field into grid issue

Al, how can I accomplish this?

You need to use something like this directly in the database.

https://www.w3schools.com/sql/sql_view.asp

Do you have access to do that with this database? And which SQL database is it?

[f_cruz]

Re: Importing field into grid issue

Can you add a view to the database?

That view can rename the field and then Alpha won't see the $

Al, how can I accomplish this?

[Al Buchholz]

Re: Importing field into grid issue

That is exactly where I am at. Everything works great except trying to add "Post$Req" and changing column name of SQL column is out of the question. Any guidance would be helpful.

Can you add a view to the database?

That view can rename the field and then Alpha won't see the $

[madtowng]

Re: Importing field into grid issue

share the component (grid) and some sample data. Everything through now has been guesswork.

[f_cruz]

Re: Importing field into grid issue

That is exactly where I am at. Everything works great except trying to add "Post$Req" and changing column name of SQL column is out of the question. Any guidance would be helpful.

[Al Buchholz]

Re: Importing field into grid issue

Divide and conquer.

Build a simple query that works and then add into it until it breaks.

Then you have what you need to focus on.

[f_cruz]

Re: Importing field into grid issue

Anyone else have any ideas of how I can get this to work?

[f_cruz]

Re: Importing field into grid issue

I tried this and now i get this. Capture.PNG

[Al Buchholz]

Re: Importing field into grid issue

Good Morning! My SELECT statement is below. I tried what you said but I don't think I did it correctly. When I try to save it, I get an error message. [ATTACH=CONFIG]46219[/ATTACH]

SELECT
o.Post$Req as 'PostMoneyReq',
o.OrderID,
o.BillToCompany,
o.ProjName,
o.FirstDrop,
o.CSR,
o.UserDefDate7,
o.UserDefDate8,
o.DPStatus,
o.DPInitials,
o.EnterDate,
o.MaterialIn,
o.DateDataChecked,
o.DataIn,
o.PDComments,
o.CloseDate,
o.ActualQtyDP,
o.ActualAmtBilled,
e.Initials
FROM tblOrders o
LEFT OUTER JOIN tblEmployee e
ON e.EmployeeID = o.CSR

SELECT 
	o.Post$Req as 'PostMoneyReq',
	o.OrderID,
	o.BillToCompany,
	o.ProjName,
	o.FirstDrop,
	o.CSR,
	o.UserDefDate7,
	o.UserDefDate8,
	o.DPStatus,
	o.DPInitials,
	o.EnterDate,
	o.MaterialIn,
	o.DateDataChecked,
	o.DataIn,
	o.PDComments,
	o.CloseDate,
	o.ActualQtyDP,
	o.ActualAmtBilled,
        [B][COLOR="#FF0000"]e.EmployeeID,[/COLOR][/B]
	e.Initials 
FROM tblOrders o
	 LEFT OUTER JOIN tblEmployee e
		 ON  e.EmployeeID = o.CSR

[f_cruz]

Re: Importing field into grid issue

Good Morning! My SELECT statement is below. I tried what you said but I don't think I did it correctly. When I try to save it, I get an error message. Capture.PNG

SELECT
o.Post$Req as 'PostMoneyReq',
o.OrderID,
o.BillToCompany,
o.ProjName,
o.FirstDrop,
o.CSR,
o.UserDefDate7,
o.UserDefDate8,
o.DPStatus,
o.DPInitials,
o.EnterDate,
o.MaterialIn,
o.DateDataChecked,
o.DataIn,
o.PDComments,
o.CloseDate,
o.ActualQtyDP,
o.ActualAmtBilled,
e.Initials
FROM tblOrders o
LEFT OUTER JOIN tblEmployee e
ON e.EmployeeID = o.CSR

[madtowng]

Re: Importing field into grid issue

Try select Post$Req as 'PostMoneyReq'. That should appease alpha.
If it doesn't, I would try a procedure to do the same thing (be sure to use make alpha use native sql).
Last, but not least, how much work would be created by changing the sql column to eliminate the $ ?

[f_cruz]

Re: Importing field into grid issue

It's in the SQL column. Alpa doesn't seem to like the $ symbol. I've tried "Post$Req" and [Post$Req] but no luck. We use SQL Server 2014 Express.

[madtowng]

Re: Importing field into grid issue

There's a good chance that's the problem. Which part has the $ in it, sql column or grid column, and what version of sql are you using ?

[f_cruz]

I have an SQL database I am pulling my info from. Into a grid. I have a column named "Post$Req" that I need but can't get it imported. Is it the "$" that is causing the issue? Is there a way around it?