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]

Hot
How does one setup a time capsule to use as a home network to allow Xbox one usage as well?set up the time capsule with an iOS device, a Mac or a PC, and then connect the Xbox to the time capsule like with any other router. however, for some Xbox fea [More]
Hi i'm sorry if it's vague, but i'm coming here without any  config simply because i don't have access. At work we have 1 Cisco ASA5505 which is used for IPSEC VPN only. We have 4-5 users that work 100% from the VPN (8h per day 40h per week) The prob [More]
This started on iChat... When starting a video conference I see a black picture, the green light turns on but my buddy only see's a video of herself and is still able to hear me. I tried opening the audio/video preferences and the preview is still bl [More]
I recently installed a new hard drive on my PC, downloaded iTunes, updated the software on my iPod touch and now I get this error message when I try to sync:  "you do not have enough access privileges for this operation."  It never did this befo [More]
Dear friends, I have created a simple AIR app with Flex, where it basically navigates toa specific URL. It works fine, all the links, and so on... however, when I need to click a specific link to download a file (DOC, XLS, PDF) from it... it just do [More]
My daughter had her infomation on the computer for her Iphone 4 and had used my wifes name.  When my wife hooked her phone up to load music.  It quickly wiped most of her pictures and info off her phone.  It does not appear when we hook the phone bac [More]
My organization provides iPads to some employees to assist them in working remotely. Most people updated their devices to ios7 on the day of release, but I waited so we could compare functionality. I'm glad I did, as there have been a few things that [More]
I am running Photoshop CC (up to date as of today) and Lightroom 5.2.  I  am hitting 2 major problems.  In Photoshop if I select File/Browse in Bridge I get the following message "Could not complete the Browse in Bridge command because Photoshop was [More]
Hi there, I am trying to find out the way to identify what was the action type for the personnel action that is just being executed. I will try to explain myself with a concrete example. Let's take the hiring action. A user goes to PA40 and initiates [More]
When I supply the value for a session variable in the URL for an IRPT page where the value contains double byte characters, Japanese in this case, the characters are corrupted by the time they are entered for the session variables.  Does anyone know [More]