Amicuk Programming Answers

Problem In The Query

2015-10-11   Views:0


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()
            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
                '//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
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
You're trying to use Table Alias(T0), i'm guessing its not allowed. Try also to remove dbo, try @EMPA or just EMPA.

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]

I'm trying to install the desktop version of Adobe Premiere, I download the 1.6 dmg file for iOS and execute it but I get an error msg with downloading files (Error code: 202). How do I solve it?It didn't work. I usually have lots of headaches to upg [More]
It is possible so copy easy the Music in Itunes to my Ipod Touch?Sry but i forgot that i use Itunes Match. Finaly i cant easy copy my Musik from my Library? So easily i want my Music that i have on my Computer simply on my Ipod and not on Stream.Read [More]
I followed all the instructions, attached the iPad, selected the device and hit "photos," then selected a folder (73 photos) from my PC.  Now my iTunes says it's syncing to the Ipad but it also says (unendingly) "Accessing iTunes Store.&quo [More]
Something like that: Select * From EMP SCOTT, MARC, WILLIAM, JOHN <<instead of>> SCOTT MARC WILLIAM JOHN graciasResources used: CREATE FUNCTION Purpose Use the CREATE FUNCTION statement to create a standalone stored function or a call specific [More]
I'm having real problems with IMessage activation same with FaceTime, the phone shows the activation is being made but it does not activate! Apple ID and password is OK, it's working with other applications Any ideas guys?!My daughters had the same p [More]
Hi I am trying a test setup of OVM3.1.1-305. I am using OpenFiler for iSCSI disks and have created 20GB iSCSI disk for Pool FileSystem and another 260GB iSCSI disk for Data Repository. The server pool gets created fine with the Pool FS and HA and Clu [More]
Hi Everybody,               I need the roles for accessing the DMS through Easy DMS. Thanks, RajeshThanks Everybody,                  I have rights to access the DMS through SAP GUI, where as i am not able to logon through the Easy DMS. The error i a [More]
Is it possible to put an < h:message> inside of a column of a JSF Datatable? I want to validate that the user is actually entering data into the text box residing in the column of the Datatable.Yes, you could, please download jsf1.1 RI and install t [More]
Hi, I want to assign authorization for a perticular Network of a perticular WBS in a PS project. BUt all the standard object i have checked dose not serve the purpose. What is the standard procedure for doing that? Any object you know can be useful t [More]
I wish to have replication from sqlserver 7.0 to oracle 8.1.7 database done in real time. Since tranparent gateway only goes from oracle to sqlserver, I guess ODBC connectivity is the last resort. Are there any other tools or methods that I can accom [More]