Hi.. I got a database in progress 10.1, i want to pull info from one field call 'sup-id', from visual 2008 in asp.net. but i got this error
ERROR [HY000] [DataDirect][ODBC OPENEDGE driver][OPENEDGE]Syntax error in SQL statement at or about "[ord_0.sup-id] FROM PUB.ord ord_0 WHERE " (10713)
this is my query:
Dim MyConnection As System.Data.Odbc.OdbcConnection = New System.Data.Odbc.OdbcConnection("Driver={Progress Openedge 10.1A Driver};DSN=PROGRESS;DB=pace;UID=sysprogress;PWD=password;HOST=192.168.10.248;PORT=2580;")
Dim MyCommand As System.Data.Odbc.OdbcDataAdapter = New System.Data.Odbc.OdbcDataAdapter("SELECT ord_0.onum, ord_0.cdate, ord_0.completed, ord_0.posted, ord_0.sid, [ord_0.sup-id] FROM PUB.ord ord_0 WHERE (ord_0.cdate>={d '2011-06-01'}) AND (ord_0.completed Is Null) AND (ord_0.sid=1)", MyConnection)
Dim DS As DataSet = New DataSet
MyCommand.Fill(DS, "ord")
aspxGridView1.DataSource = DS.Tables("ord").DefaultView
aspxGridView1.DataBind()
can i can help me please...?
ERROR [HY000] [DataDirect][ODBC OPENEDGE driver][OPENEDGE]Syntax error in SQL statement at or about "[ord_0.sup-id] FROM PUB.ord ord_0 WHERE " (10713)
this is my query:
Dim MyConnection As System.Data.Odbc.OdbcConnection = New System.Data.Odbc.OdbcConnection("Driver={Progress Openedge 10.1A Driver};DSN=PROGRESS;DB=pace;UID=sysprogress;PWD=password;HOST=192.168.10.248;PORT=2580;")
Dim MyCommand As System.Data.Odbc.OdbcDataAdapter = New System.Data.Odbc.OdbcDataAdapter("SELECT ord_0.onum, ord_0.cdate, ord_0.completed, ord_0.posted, ord_0.sid, [ord_0.sup-id] FROM PUB.ord ord_0 WHERE (ord_0.cdate>={d '2011-06-01'}) AND (ord_0.completed Is Null) AND (ord_0.sid=1)", MyConnection)
Dim DS As DataSet = New DataSet
MyCommand.Fill(DS, "ord")
aspxGridView1.DataSource = DS.Tables("ord").DefaultView
aspxGridView1.DataBind()
can i can help me please...?