Hiya,
Thanks for the response.
We are using SQL Server as the Backend and the client's SAP Dept has supplied a RFC as the only means of communicating with SAP.
We were thinking of the Excel option (Creating an Excel File and uploading this) but the client's SAP dept refused.
Cheers
Leon
Echidna
Last Activity: Jan 23 '13, 10:13 AM
Joined: Jan 22 '08
Location: Aberdeen, Scotland
-
Hi All,
We got it working, was not the Data type at all, but the RFC not accepting the Identifier of the Object Column.
Changing the Reference to the Ordinal number of the object worked.Leave a comment:
-
SAP RFC - Numeric character Headache
Hi All,
Wondering if anyone has encountered this one, and if anyone has a solution (or an insight into what's going wrong)
This has been bugging us now for quite a while, and cannot find a solution.
We are attempting to Write test data from a VFP9 Application local cursor into a SAP Object.
We can create a new line, and the RFC returns that the new line exists, but when we attempt to insert the... -
Hi,
I will take you through option 1
The SQL Statement needs to be rewritten slightly.
The Columns you have selected need to be in the same order and of the same data type within the values clause as the column list within the INSERT INTO statement.
example
Col1 is Datetime datatype
Col2 is Integer datatype
Col3 = char datatype
...Code:docmd.runsql "INSERT
Leave a comment:
-
Hiya,
Got it to work... finally :)
One of the VFP developers suggested a "try catch", which got me thinking :)
Here is what i came up with
...Code:CurrentProject.Application.RefreshDatabaseWindow Me.txtdisplay = "Processing..." Screen.MousePointer = 11 gcdate = Now() Do While Now() < gcdate + 0.00003Leave a comment:
-
Thanks for the tip :)
the advantage of having a standalone testing environment :)
It was set originally to 5 seconds (odbc default), i am thinking of taking the original idea of 'holding' the application for 5 seconds to allow the odbc to refresh itself, but everything i try does not work (short of killing the connection and re-establishing the link).
Is there some way within an adp of determining if the...Leave a comment:
-
Hi, sorry for not responding in a while, I have been given another priority one project for the past couple of weeks.
I set the odbc refresh interval to one second and it works a charm now... many thanks :)
Cheers
LeonLeave a comment:
-
Hi,
I would suggest setting up a table with the hours in the day 1 - 24 (or am/pm) or something similar.
then creating a view from this as a left outer join to the table, the datepart(hour,g etdate()) function can then be used to limit the number of records produced.
so something like this could work.
...Code:SELECT timename, eventname from ( SELECT timename, eventname from tbltime
Leave a comment:
-
I have changed the code within the excel formatting, but the issue - error 7874 is still there.
I commented out the excel formatting, and the problem still exists.
It seems that the table exists on the server, however, there seems to be a delay in the Database window being populated with the Table created.
Cheers
LeonLeave a comment:
-
Many Thanks guys :) will give it a go this morning :)
Did not think of the excel automation causing an issue...
I recorded a macro and copied the VB straight into Access.
Cheers
LeonLeave a comment:
-
Hiya,
not such thing as a dumb question :)
I have the excel library referenced.
I have set a breakpoint, and the error is coming up (occasionally) at the docmd.transfers preadsheet line.
If i run the script again (after the error), the spreadsheet is produced.
Cheers and Thanks
LeonLeave a comment:
-
Access Lagging behind SQL Server
I am trying to export a query held within a table as T-SQL out to excel.
The idea is to have admins write the Queries, which will be exported by other personnel.
The View and Table do create correctly as I can see them within ssms, however I get a runtime error 7874 - cannot find object.
The only thing i can think of is that access is lagging behind sql server, and the database window is not being refreshed.
... -
Hi
Hope this helps.
...Code:=DCOUNT("Employees","Employees","[EmpCategory]= 'CatA'") =DCOUNT("Employees","Employees","[EmpCategory]= 'CatB'") =DCOUNT("Employees","Employees","[EmpCategory]= 'CatA'") + DCOUNT("Employees","Employees","[EmpCategory]= 'CatB'")Leave a comment:
-
Hi,
For the report, are you wanting a summary style ie
Category A 50
Category B 112
etc
or something more comprehensive like
Category A 50
Category A member 1
Category A Member 2
etc
Cheers
LeonLeave a comment:
-
Hi
So something like
Hope this...Code:SELECT a.rollno, CAST(SUBSTRING(b.crseno,1,5) + ' - ' + CAST(COUNT(SUBSTRING(b.crseno,1,5)) AS VARCHAR(2)) AS VARCHAR(10)) AS crse FROM a INNER JOIN b ON a.crsid = b.crsid WHERE (a.rollno='CE08B013') GROUP BY a.rollno,b.crseno HAVING (CAST(COUNT(SUBSTRING(b.crseno,1,5)) AS INT)>1) order by b.crseno
Leave a comment:
-
Are these columns you are referencing within the statement:
within a single table or view?Code:select a.rollno,count(substring(b.crseno,1,5)) as crse from ucsrgdet a,corsemst b where a.rollno='CE08B013' and a.crseid=b.crseid group by a.rollno,b.crseno having count(substring(b.crseno,1,5))>1 order by b.crseno
Cheers
LeonLeave a comment:
-
No Probs :)
Glad I could help
Cheers
LeonLeave a comment:
-
Hi,
Hope this will help.
CheersCode:CAST(SUBSTRING(b.crseno,1,5,) + ' - ' + CAST(COUNT(SUBSTRING(b.crseno,1,5,)) AS VARCHAR(2)) AS VARCHAR(10)) AS crse
LeonLeave a comment:
-
That would display the data within the fields selectedLeave a comment:
-
Yes it would.
So something like issue.rowsource = "Select columnname1, columnname2 from Table"
make sure the number of columns you are selecting within the rowsource = the number of columns within the combobox
Cheers
LeonLeave a comment:
No activity results to display
Leave a comment: