Sitemap

Amicuk Programming Answers

Problem In The Query

2015-10-11   Views:0

Advertisement

Hai All,            I have created a login form in screen painter (which contains two textbox and a login button). When login button is clicked, I want to check whether the username and password matches in the table (@EMPA). I have a problem while ch

Hai All,
           I have created a login form in screen painter (which contains two textbox and a login button). When login button is clicked, I want to check whether the username and password matches in the table (@EMPA).
I have a problem while checking with the query
This is User Defined Function a have used
Private Sub UDFCheckInTableLog()
        Try
            Dim rs As SAPbobsCOM.Recordset = ocompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)
            rs.DoQuery("SELECT T0.U_user FROM [dbo].[@EMPA]  T0 WHERE T0.U_user ='" & euser & "' AND TO.U_pass ='" & epass & "'")
            rscount = rs.RecordCount
            If rscount > 0 Then
                '//There is a record that Matches
                REC = True
                '//To clear the values in the text box
                UDFClear()
            Else
                '//This means NO Record Matches
                REC = False
            End If
        Catch ex As Exception
            SBO_Application.MessageBox("UDFCheckInTableLog :" & ex.Message)
        End Try
    End Sub
I get this error message
UDFCheckInTableLog:
1)[microsoft][ODBC SQL Server Driver][SQL Server] Incorrect syntax near the keyword 'TO'.
2))[microsoft][ODBC SQL Server Driver][SQL Server] Statement(s) could not be prepared.

The replay answer
Advertisement
Hi,
You're trying to use Table Alias(T0), i'm guessing its not allowed. Try also to remove dbo, try @EMPA or just EMPA.
HTH
Manuel

Go to See the other 6 answers

Problem in Adhoc Query's set operation functionality.

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts, I am facing problem executing Adhoc Query's set operation functionality. In Selection Tab, following operations are performed :- Execute a query and mark it as 'Set A'.(Say Hit list = X) Execute another query and mark it as 'Set B'.(Say H[More]

Problems in SQL Query

Category:DefaultRelease time:2015-10-11Views:130

Dear All, I am having some problem in SQL query. I am trying to get total sum of one inventory using the following query it works fine: sum(case when mt.transaction_quantity > 0 then (mt.transaction_quantity) else 0 end) "TOT_IN" ,sum(case wh[More]

Problem with a query with a BLOB data type

Category:DefaultRelease time:2015-10-11Views:130

Hi i've a problem with this query in 11g. R1 SELECT       LOGTIMESTAMP,       LOGTIMEMILLIS,       MSGID,       XMLTYPE(MESSAGEBODY, nls_charset_id('AL32UTF8')).getClobVal()  as LLamada FROM     vordel.AUDIT_MESSAGE_PAYLOAD,     vordel.AUDIT_LOG_POIN[More]

Strange problem in a query

Category:DefaultRelease time:2015-10-11Views:130

Hello all, I'm facing a non-sense problem in a query, I hope you could help me. I have defined a structure in the rows of my query. Inside the structure, I have defined several selections and formulas. Selections are basically account intervals and f[More]

Problem in parameter query.

Category:DefaultRelease time:2015-10-11Views:130

Post Author: eaglesoft CA Forum: Data Connectivity and SQL I'm using Crystal reports xi. I have problem on parameter fields.    field name-EmployeeCode, datatype-String.In report,I kept the following query in selection expert,(EmployeeTable.EmployeeC[More]

Problem in xml query

Category:DefaultRelease time:2015-10-11Views:130

Hi I am working on BLS and having problem in xml query.I want to perform some calculation over xml columns.Than total of this as a new column.I can do this part in logic editor itself but can i do these both task by XSLT. Can be made our own XSLT for[More]

Navigational Attribute Problem in Input Query

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am having a problem in input query implementation which uses a navigational attribute. I have, for eg, only one char 'customer' in rows; i want to exclude the customers with the status D (deleted) from displaying (Status is nav. attr. of custom[More]

Problem in update Query of  MySQL

Category:DefaultRelease time:2015-10-11Views:130

Hi I have a large amounts of records in a teble & i want to update the records in a particular condition but it takes time in updating. I have also used batch update but it's also not going to solve my problem. can anyone help what should i do to fre[More]

Problem With The Query

Category:DefaultRelease time:-0001-11-30Views:130

Hi gurus, I have a problem in a query I have a lot of records that are the same and I don’t want to sum the value of them more than once. How can this be done?? The following table should illustrate my problem: DEPT--MONTHCFBID----SCORE ALST--APR100-[More]

Problem with Hierarchical query

Category:DefaultRelease time:-0001-11-30Views:130

Gurus, I have a problem with hierarchical query, which I am pasting below. select sys_connect_by_path (Fname,'/')"PATH",Fname,id,level ,(SELECT COUNT(ID)-1 FROM (SELECT CONNECT_BY_ROOT LNAME LNAME,ID FROM CMT_PERSON START WITH ID = 'emplo0000000[More]

Problem with af:query

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have a problem with af:query. Here's what I do: 1. create a VO, define view criteria 2. drag and drop view criteria from data controls to an empty form, choosing query and table 3. When I run the page and click any of the buttons, I get: "Becau[More]

Hot
My father in law has an iPad only--no computer to run iTunes on. He doesn't want to associate a credit card with his store account. We've showed him how to redeem iTunes gift cards, but can't figure out how to show his credit balance (again, on the i [More]
Hi I got the following error when i am trying to delete a Page Group. How can i rectify this. Portal Version:9.0.2.2.14A Error: An unexpected error has occurred (WWS-32100) ORA-1: User-Defined Exception (WWC-36000) Error while deleting page. (WWC-441 [More]
Is it possible to install OS Lion on an external Hard Drive and use that to boot up a laptop computer? Thanks, ASRN, Thanks for the link. Regarding "homework", I am not sure what qualifies in your world but I had done a fair bit of searching for [More]
Hello all, I need some help... I am building a series of logos — based on word strings —  using Illustrator CS4 with a combination of Actions, but also retrieving the word string from an Excel file. Normally for one or two iterations of the process, [More]
Hello All, So I'm looking for some help here. I have my iTunes in basically perfect order but the one thing I can't figure out is that when sorting by artist (or even by album for that matter). Some albums have a one line space between them and other [More]
I was wondering if anyone knows if ADFS 3.0 supports the AD flag "Force password at first login"?  I know 2.0 does not. I have been integrating Shibboleth with my ADFS and a custom login handler but I would really like to not complicate my setup [More]
Hello, I have a field in my database with an archived date... (Giampaoli  Live Oak, Almonds Archive 09/16/10) I need to be able to extract the date from this, then perform a datepart function on it... How do I extract the date into it's own value usi [More]
Hey All, Does anyone know of software that will scan the Itunes library and fix any corrupted ID3 tags? About 20% of my songs (and growing) wont import or add to Itunes. I suspect it is because of corrupt Id3 tags??? Anyone else found a solution to t [More]
I have two user accounts on my Macbook pro.  In one of my user accounts the Smart Search disappeared.  How do I get it back?http://www.redmondpie.com/safari-6-for-os-x-lion-now-available-features-smart-se arch-field-offline-reading-list-and-more/Read [More]
Hi i'm new at fiber world. Could anyone tell me how can i install 2 xserve raid on 1 xserve? In this moment i have 1 Xserve and 1 Xserve RAID conected directly with 2 fiber cables. I need to buy other xserve RAID but how can i conect it? i have to us [More]