Importing field into grid issue

[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?

[madtowng]

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]

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]

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]

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

[Al Buchholz]

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

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.EmployeeID,
	e.Initials 
FROM tblOrders o
	 LEFT OUTER JOIN tblEmployee e
		 ON  e.EmployeeID = o.CSR

[f_cruz]

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

[f_cruz]

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

[Al Buchholz]

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]

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.

[madtowng]

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

[Al Buchholz]

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 $

[f_cruz]

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]

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?