I am trying to compare records from oracle table with a table in access. With oraDynaset, I have the option of .findNext function. I can use that to look for matching records from access to oracle.
My problem is: I have to look up in access table and delete the records from oracle table if a certain record is not available in the access table.
Is there a way of doing that ? Can I get some help ?
To make my point more clear, here...
NasirMunir
Last Activity: Nov 14 '07, 04:28 PM
Joined: Jun 11 '07
Location:
-
comparing records of oracle table with access table
-
Shell is still not working fine for me, the way I want. The executable is not running from the directory/path I am providing in the shell statement.
...Code:Private Sub Command3_Click() Dim src As String Dim des As String Dim Count As Integer Dim resDes As String Dim Result As String Dim i As Integer Dim runExe As Double Dim finPath As String -
running executable with shell
I am trying to run an executable using shell. The executable look for certain files in the same directory and then run on those files.
My problem: I have created a form which asks from the user to locate those files using browse option. Then I ask the user to locate the executable. The next step is to copy the executable to those files directory. Everything is dandy uptil here, but when I use the shell to run that executable, the executable... -
thanks for the prompt reply!!!Leave a comment:
-
Copy file from source to destination
This may be pretty simple, but I need some help here.
Can anyone point me in the right direction to copy a file from one location to another in VB6 ? I have tried using File System Object but couldn't go much farther. "user-defined type not defined" error message pops up.
Thanks -
Thanks to all.
After banging my head for few days, I figured it out how to do that :). I was not aware of command dialog box. At any rate, thanks again for all the help....Leave a comment:
-
creating a browse button with VB6
I need some help for creating a button that can allow the users to browse to a location and upload a file. I am new to VB, and any help would be greatly appreciated. -
I forgot to list a line which might be the problem (I don't understand the objects used to open the recordset.
...Code:recordset.Open SQLstr, strCnn, adOpenStatic, adLockOptimistic, adCmdText
Leave a comment:
-
VB 6.0 and SQL query retrieval
I am trying to retrieve rows from an access database, the table name is FE_LOG_DATA. I can see the rows being returned when I use the access query mode in access, however when I try to do that with VB code I am having troubles.
The query I am using is:
If I dont use IS_IMPORTED then I am fine, but...Code:SQLstr = "Select * From FE_LOG_DATA Where (IS_IMPORTED= 0 Or IS_IMPORTED Is Null) And IS_CREATED = False"
-
I have been able to resolve that with access. I created linked table in access, made updates and it did the trick of updating the oracle table as well.
I would still like to know some other way of doing that too. I am wondering, if that is possible through enterprise manager console ?Leave a comment:
-
sweet !!!
worked perfectly, Thanks a lot.Leave a comment:
-
copying table from one schema to another
is there a way of copying a table from one schema to another schema with oracle enterprise manager console? If not, how can I accomplish this
Thanks -
copying table from oracle to access
The problem: I have two schemas in an oracle database. One of the schema is the updated one. I want to update the first schema table say table A with the updated table A of schema B. The first table may have 74 rows as compared to 78 or more(for example).
I am thinking about copying the table to access and then copy it back to oracle. I may be entirely wrong, but can't think anything else. Can anyone suggest something or advise how can I do... -
didn't work, can you explain a bit more ?
thanksLeave a comment:
-
displaying search result in an excel format or else
I have created a table in access (copied from excel). Then I created a form which contains a text field and a list box. The text field is actually a look-up field, where a user can enter a searchable text and the results are displayed in the list box(the search is done on the table which I copied from excel). Everything works fine as I want.
The problem: I cannot copy the results from that list box to the excel sheet. It just copies the first... -
YES :),
Thanks a lot, case solved.Leave a comment:
-
problem with retrieving all fields of the table
I just copied a table to access from excel. I named that as "Contents".
I am trying to create a look-up field on a form which can return the tuples in a list box. My code is:
...Code:Option Compare Database Private Sub List3_BeforeUpdate(Cancel As Integer) End Sub Private Sub Text0_BeforeUpdate(Cancel As Integer) Dim holdVal As String holdVal -
thanks a lot for the help, case is resolved.
Actually I was using the wrong table name :), my bad. It works fine now.
The "IIF" sttement suggested earlier is right, I was wrong.
God BlessLeave a comment:
-
okay, that circular reference is settled, i used
but now another problem: It is displaying all as -1, i guess because it is looking at the check box field and is returning true for that.Code:SOW: IIf([Design and Qualification].[SOW],-1,0)
My problem is to find the field checked or un checked and accordingly assign -1 for checked and 0 for un checked.
Need some help here,
Tha...Leave a comment:
-
I am still struggling with IIF statement: the error suggests the circular reference, any help ?Code:SOW: IIf([SOW],-1,0)
"Circular reference caused by alias 'SOW' in query definition's SELECT list"Leave a comment:
No activity results to display
Leave a comment: