I wrote Stored procedures returnes: field1,field2.
When I execute SQL like this: Select * FROM myStProc
Firebird returns field1,field2 and its values.
OK.
But if I want do something like this:
Select S.field1 FROM myStProc S
or
Select S.*,T.name FROM myStProc S, names_table T
Where S.field1=T.id...
Hello,
To this day I try learn many languages to create database application.
Now I am confident that Delphi is the best!
But in Delphi are a lot of components and even I bought good book about Delphi it doesn't explain me exactly interesting me things...
So, my question is:
Do you know where...
I want create shortcut to my exe file in start/programs group.
So I have file 'rejestrator.exe' i mark 'M Item' checkbox i fill Description as 'rejestrator' command line:
'%srejestrator.exe' (i try also:
'%s\rejestrator.exe' and '%s/rejestrator.exe') and when I run setup it shows message that...
So, I don't give up...
Here is packed my test project.
http://www.pbr.pl/testy.zip
I compile it to exe file.
And when I run it's in 3 copy (local on my PC) I see Attempting to lock
The same problem I have in my network...
There is simply relation in form.
In init method in form I issue
set...
I try to use VFP...
But it makes many difrent things which I can't explain...
I still have lock problem and so on...
I try to use Deplphi with Interbase - and That's it!
Hello,
I'm clipper programist, and I want to write my application in Windows.
Im looking for good and easy to learn language to program databases application.
I heard Delphi is easy and powerful in that.
Do you agree with this? Or I rather should look for something else ?
I'll be grateful...
I tested my app in my PC – I run it several times and all worked fine. But when I installed Database on network drive (F:) I can run just 2 copy of App, when I try to run 3th app copy and open some tables I still can see magic words ‘Attempting to lock, press ESC….’
I wrote some programs in...
Please tell me what is better:
running my .exe application form network drive or local (and only databases from network).
I reflect on follow in at 'attempting to lock' message...
I want detect if record is locked or not.
Is in VFP any function that return .t. if current record is locked or .f. if not ?
Or how can I detect it other way...
Thanx a lot!
I use one view on my form. I set "private datasession". When I run program in network program often hung up (then user can see message "Attempting to lock, press ESC...") and nothing is happen...
I thing that view only read record from base table(s) so I don't understand...
Sorry 4 waste your time, but I still have big problem (for me):
1. I have a view (my_view) and table (main.dbf)
2. I do something like:
"INSERT INTO my_view start VALUES (datetime())"
3. next: TableUpdate(1,.t.,"my_view")
4. now, if I want delete this record:
DELETE IN...
I heard that PB is very good tool. I'm interested in learn PB, but in my country (Poland) I can't find any books.
Anybody knows where I can buy it or which title is the best?
I don't have PB too. Maybe some1 knows where I can find trial version (or such:) ?
please let me know if you can help me...
I try explain what I kind of problem I have:
I don't know how:
update (just inserted) record in view and update its base tables
For example:
I've table:
main.dbf
-----
ID USER_ID JOB START_TIME STOP_TIME
1 1 "abc" 01-02-01 12:20 01-02-01 12:40
2 ...
I can INSERT all fields as I want to view, and it's update base tables & looks good...
but if I want second time update view's record (when I just insert in view) I can't: when I browse this view it has empty ID_MAIN field (key field) (the same as in main table) but if I close view and reopen...
I try many times show in Report more than 1 tables (in telation with other) but I don't know how! I read that I should use grouping - I'll do it but still I have stupid data in preview...
Ok, I have something like:
table-1 table-2
ID
1. .... +- 1.1. .....
|- 1.2...
Why when I add in my view
new record (APPEND BLANK .. IN)
and fill more 1 field (REPLACE... IN)
I have update confilct (apter tableupdate) ?
So, I must insert new row, close and re-open view, and from this time I can update how many fields I need...
It's possible to do it by other way (my...
When I run generated file setup.exe all files installing corectly, but setup don't creatw desctop icon and group in start menu (I check this option in wizard)...
Any1 knows why ?
I create updatable SQL view. It's nessesary to all data be actual for other users so after all data update in view I execute tableupdate(). All works fine but when I insert row in view I have update confilct. I read in manual that at least 1 updatable field must be fillled - so I do this and it...
Hello!
I have big problems in programming to te network use. I wrote an aplication. Placed in server, and all user run it by te LAN (I don't know - maybe better will be if they run it from your own local drives and only database will be shared ?). Application works well but when users run...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.