baze.podataka.203dvesic,
-> #198, mmarkovic> Dakle, siguran si (i dvesic koji pomenu CURSOR, što je standardni
> način pristupa selekciji) da smo se razumeli?
> Pokrenem upit na serveru, i DOK ON JOŠ TRAJE prikazujem na klijent
> računaru red po red odgovora.
> Po potrebi PREKINEM OBRADU NA SERVERU.
Ajde jedan kratak primer ;) (izostavljene su uobičajene kontrole, radi
lakšeg praćenja.
// Definicija upita; na serveru se još ništa ne dešava
DECLARE SelCust CURSOR FOR
SELECT Name, Id, Adress
FROM Customer
WHERE Id > 100;
// Otvaranje kurzora. Početak obrade
OPEN SelCust;
lb_Ok = TRUE
// Petlja za obradu
While lb_Ok
// Pokupi slog
FETCH SelCust INTO :ls_Name, :ln_Id, :ls_Adress;
lb_Ok = (SqlCa.SQLCode = 0)
// SqlCa.SQLCode = 100 znači da su svi slogovi pokupljeni
IF lb_Ok THEN
// Obrada sloga
END IF
End While
// Kraj obrade
CLOSE SelCust;
Sva kontrola je tvoja. U svakom trenutku možeš iskočiti iz petlje
i prekinuti obradu (Close).
Sad smo se razumeli ?
baze.podataka.204jmiodrag,
-> #154, mmarkovic >> Kod DOS-Novell kombinacije sa Access Serverom, preko zice idu samo
>> ekrani i otkucaji na tastaturi (kao TeleReplica ili PC Anywhere)...
Ovo mi treba.Gde to ima i pod kojim se imenom tacno prodaje.
baze.podataka.205mmarkovic,
-> #203, dvesic1. > // Definicija upita; na serveru se još ništa ne dešava
>
> DECLARE SelCust CURSOR FOR
> SELECT Name, Id, Adress
> FROM Customer
> WHERE Id > 100;
Dakle, ovo je na serveru? Kod je trenutno u programu-klijentu, ali
će biti prosleđen serveru da ga on odradi?
Mogu li ovo da definišem kao "stored procedure", da ima parametre,
i da stalno stoji na serveru?
2. Znači,
SqlCa.SQLCode = 0 znači "možda ima još", a
SqlCa.SQLCode = 100 znači "gotovo! završena obrada-upit" ?
3. OPEN SelCust - pokreće upit-obradu na serveru
CLOSE SelCust - trenutno prekida obradu-upit na serveru
?
> Sad smo se razumeli ?
Mislim da jesmo.
baze.podataka.206mmarkovic,
-> #204, jmiodrag> >> Kod DOS-Novell kombinacije sa Access Serverom, preko zice
> >> idu samo ekrani i otkucaji na tastaturi (kao TeleReplica ili
> PC Anywhere)...
>
> Ovo mi treba.Gde to ima i pod kojim se imenom tacno prodaje.
Program se zove Access Server, prodaje ga Novell, mada nije njihov
proizvod, ali su kupili licencu. To mu je tačno ime.
Funkcioniše sa NetWare-om 3.11 i 3.12. Verovatno i sa 4.x. Nema
razloga da ne funkcioniše.
Na jednoj od stanica se instalira ovaj software, WNIM (ili beše
WNIM+) kartica. Ovo je kartica sa 4 serijska porta. Nažalost,
ne funkcioniše sa običnim COM portovima.
Ostali smo bez uputstva, ali WNIM nije jedina kartica koja
može da se koristi, bile su još neke. Ova kartica je bila dosta
skupa (par hiljada DEM).
Na ta 4 porta kačiš eksterne modeme i vodiš na komutirane ili
iznajmljene linije. U računar možeš da staviš do 4 WNIM kartice,
dakle 16 spoljnjih stanica.
Access Server blisko sarađuje sa DesqView multitasking software-om
sa kojim ide u paketu. Svaki task, a i ceo paket, radi pod DOS-om
3.30
Što više memorije imaš, može da pristupi više stanica. Sa 4MB mogu
dve istovremeno. Mošto je ta stanica u LAN-u, nema nikakvog usporenja.
Ako je u pitanju brži računar, operateri mogu čak osetiti i ubrzanje.
Za poziv se koristi poseban program (ide u paketu), mada, kao može
i recimo Telemate. Nama nije uspelo sa običnim kom.programima, ali
nismo se nešto ni trudili. Ovaj vrši pos'o ;)
Ide i program za fajl transfer, mada dosta slab. Srećom, fajl transfer
u ovim situacijama obično nije primaran.
baze.podataka.207peacock,
-> #201, nensky#### Ima li zainteresovanih za grupasenje na temu CLARION-a?
Ima :)
baze.podataka.208dvesic,
-> #205, mmarkovic> > DECLARE SelCust CURSOR FOR
> > SELECT Name, Id, Adress
> > FROM Customer
> > WHERE Id > 100;
>
> Dakle, ovo je na serveru? Kod je trenutno u programu-klijentu, ali
> će biti prosleđen serveru da ga on odradi?
U principu je upit u programu/klijentu, ali se preko odbc/native
drajvera prosleđuje serveru.
> Mogu li ovo da definišem kao "stored procedure", da ima parametre,
> i da stalno stoji na serveru?
Postoji i ta varijanta, ali praktično se ništa ne dobija; razlika
između vremena potrebnog za slanje ovog upita serveru i poziva
SP je dovoljno mala da bi to bio razlog za korišćenje SP-a.
Naravno, smeštanje Bussines Rules na server su sasvim druga priča,
i tu bi ovo poglavlje imalo posebno mesto.
> 2. Znači,
>
> SqlCa.SQLCode = 0 znači "možda ima još", a
> SqlCa.SQLCode = 100 znači "gotovo! završena obrada-upit" ?
Da.
SQLCode=0 znači da je operacija (FETCH) prošla uspešno; 100 znači
da nema više slogova koji zadovoljavaju dati uslov.
baze.podataka.209nimi,
-> #199, mmarkovic> Radnim danom ima oko 1000 transakcija (jedna transakcija sadrzi
> i dugovnu i potraznu stranu). Nekim posebnim danima u mesecu
> (obracuni kamate,...) ima i desetak hiljada transakcija.
> Sve u svemu, recimo 400-500.000 transakcija godisnje. Otprilike.
> Prelazak na ORACLE je pre svega zbog ugradivanja poslovnih
> pravila u bazu. Sumnjam da cemo u performansama nesto dobiti.
> Clipper je alat niskog nivoa, i, pravilnom upotrebom, postovanjem
> osnovnih pravila u definisanju baze, moze se napraviti veoma
> efikasna aplikacija.
>> Kupi ga u Nis pa neces da placas :))).
Dugo se nisam javljao :(, obacveze :)).
Pre par dana (10-ak) sam na Estrella (Bull-ova verzija PowerPC) sa
64MB RAM-a, 3*2.1GB diska u tabelu prometa ucitao 320.000 zapisa
(cca 50-ak MB). Nad tabelom su bila podignuta sva poslovna pravila,
indeksi, ... Proces je trajao 27 minuta.
Napominjem da SQL*Loader kojim je vrseno punjenje nije posebno
optimizovan, odnosno uzeti su sve default parametri ukljucujuci i
taj da posle svakih 64 zapisa izvrsi commit.
Dodatna napomena je da datoteka nije bila sortirana ili slicno.
Inace odgovori na petocifren deo konta (od 11) bio je trenutan.
Scan tabele sa izracunavanjem (zavrsni list) radio je za 20-ak sec.
Mislim da ce tvojih 400 000 do 500 000 da izdrzi :)).
> Adresa? Telefon?
Uskoro planiram da posetim Nis :))).
baze.podataka.210mmarkovic,
-> #209, nimi> Dugo se nisam javljao :(, obacveze :)).
Ako, ako... Kad ima obaveza, ima i love :)))
> Inace odgovori na petocifren deo konta (od 11) bio je trenutan.
> Scan tabele sa izracunavanjem (zavrsni list) radio je za 20-ak sec.
Koliko ova tabela ima zapisa i kolika je?
> Mislim da ce tvojih 400 000 do 500 000 da izdrzi :)).
I meni se čini!
> Uskoro planiram da posetim Nis :))).
Radujem se :)))
---------------
Komparacija: ORACLE vs PROGRESS? Imate li iskustva sa oba?
baze.podataka.211mmarkovic,
-> #209, nimi> Pre par dana (10-ak) sam na Estrella (Bull-ova verzija PowerPC)
> sa 64MB RAM-a, 3*2.1GB diska u tabelu prometa ucitao 320.000
> zapisa (cca 50-ak MB). Nad tabelom su bila podignuta sva
> poslovna pravila, indeksi, ... Proces je trajao 27 minuta.
Zaboravih... Koji OS, koji ORACLE?
baze.podataka.212.ken.,
Potrebna pomoc:
Krivac: Oracle verzija 5
Povredjeni: jedna moja vrlo dobra drugarica
Problem:
S vremena na vreme dolazi u stvari do dva problema.
Jedan je da dolazi do mrtvih stanja kada Oracle se sam od sebe zaglupi
(problem pokusan da se resi tako da se u FORMS-u pokusa promeniti
redosled
otvaranja relacija (tabela).Problem delimicno ublazen ali nije i
eliminisan)
Drugi problem je da (opet s vremena na vreme) dodje do zakljucavanja
odredjenih polja (ROW) i da ne znamo kako da ih otkljucamo a da ne
rusimo
sistem (COMMIT i ROLLBACK iz SQLPLUSA ne rade svoj posao).
Znaci dodje do zakljucavanja polja i oni u ODS se vide kao EXCLUSIVE
i to
polje ostaje zakljucano do rusenja sistema).
P.S. - na zalost ne postoji mogucnost (materijalna a i ostale) da se
predje
na neku drugu verzi nr-SYPdrav Ken
baze.podataka.213nimi,
-> #210, mmarkovic> Koliko ova tabela ima zapisa i kolika je?
To je ona napunjena loader-om (320.000)
Pozdrav Milan
baze.podataka.214nimi,
-> #211, mmarkovic> Zaboravih... Koji OS, koji ORACLE?
AIX 3.x (IBM-ov UNIX 12% ukupnog UNIX trzista, sto
je znatno vise od sledeceg konkurenta)
Oracle7 (7.1.7.x) za AIX
baze.podataka.215mmarkovic,
-> #213, nimi>> Koliko ova tabela ima zapisa i kolika je?
> To je ona napunjena loader-om (320.000)
Neverovatno!
50 MB u 20 sec! 2.5 MB/sec sa obradom...
(ili ipak ne čita celu tabelu, nego nešto preskače?)
Mislio sam da su u toj datoteci transakcije, a da su se te
brojke odnosile na datoteku stanja.
Kakve diskove ima to čudo? Vezane u RAID?
Stvarno brzo...
baze.podataka.216velicko,
-> #212, .ken.> na neku drugu verzi nr-SYPdrav
A šta je to SYPdrav?
baze.podataka.217nenad,
-> #214, nimi> AIX 3.x (IBM-ov UNIX 12% ukupnog UNIX trzista, sto
> je znatno vise od sledeceg konkurenta)
>
> Oracle7 (7.1.7.x) za AIX
Eh, AIX... U tom slučaju je mašina bar neki PowerPC, ako ne i
RS/6000. ;)
baze.podataka.218nenad,
Informix extends servers with replication, central management
Informix Software Inc. will help database administrators
(DBAs) stay on top of distributed database environments by
adding heterogeneous replication, enterprise management, and
expanded Web access to its line of relational databases, the
company announced Tuesday.
The Informix Comprehensive Replication software will come in
two versions set for release by the end of the year.
The first will address only Informix databases and is aimed at
smaller, workgroup sites. It will support publish and
subscribe replication across Informix OnLine Workstation,
OnLine Workgroup Server, and OnLine Dynamic Server.
Branch managers will be able, for example, to subscribe to
data from a central site or publish data to a central
location. The software includes a Windows 95 setup Wizard to
guide users in establishing replication policies.
Informix will also offer an enterprise version of the
replication software that will support peer-to-peer
replication with a cross-platform option. In this model, all
data changes on a single server can be propagated throughout
the network.
For peer-to-peer replication across IBM, Sybase Inc., Oracle
Corp., and Microsoft Corp. platforms, users will be able to
purchase Praxis International Inc.'s OmniReplicator from
Informix. The OmniReplicator option will cost $595 per user.
The other replication software will be offered at no extra
charge.
Analysts said the more sophisticated and cross-platform
replication is needed.
"[Informix] is rounding out their product line here," said
Nagraj Alur, a principal analyst at Database Associates, in
Morgan Hill, Calif. "IBM has Data Propagator, and Oracle has
their Symmetric Replication product."
In enterprise management, Informix has added a central DBA
console and an SNMP management information base (MIB) to its
OnLine family of servers. The MIB will allow network managers
to directly monitor Informix database performance from
management platforms, including Computer Associates
International Inc.'s Unicenter, IBM's Tivoli Management
Environment, Hewlett-Packard Co.'s OpenView, and Sun
Microsystems Inc.'s Solstice.
Informix's own console, the Informix Enterprise Command Center
(IECC), which communicates via the Internet InterORB protocol,
will give DBAs a single point from which to mange multiple
Informix databases.
"Whenever you have distributed databases, you need a single
point of control," Alur said. "We shall wait with baited
breath to see how well it performs."
IECC uses CORBA agents deployed on the distributed servers to
perform DBA tasks. It will be bundled with the database for
free within six months.
The console gives users two interface options: they can manage
through a standard Windows application or download a Java
applet that will open a management interface from a Web
browser.
Informix is also extending support for Netscape Communications
Corp.'s Enterprise Server and Navigator browser across the
entire OnLine server line. The Workgroup Server is bundled
with Netscape software, and Informix's OnLine Dynamic Server
and Extended Parallel Server with Enterprise Server and
Navigator are available immediately.
Pricing was not available.
baze.podataka.219nenad,
Sybase extends SQL Server functions to Web publishing
Sybase Inc. on Tuesday introduced a strategy to allow users to
create database-driven Web sites based on a new version of the
Sybase SQL Server, code-named "Sybase SQL Server
Professional."
The new server will give users a way to manage content in
databases and on Web sites, by helping database administrators
manage the Web using the tools and skills they have instead of
having to learn new ones for the new platform, officials said.
Included in "Professional" is NetImpact Dynamo, a Web
application server which generates and updates dynamic HTML
and publishes information from the database directly onto the
Web. It will be integrated with Sybase SQL Server 11, giving
administrators a server which will manage both the database
and Web aspects of the system, as well as storing all of the
Web content in the database.
Dynamo supports both the Netscape API and the Microsoft
Internet Information Server API, and with wizards, lets
developers create HTML pages with embedded SQL statements and
scripts that serve as templates.
Also included are sample sites, a template gallery, and a
built-in scripting language that is compatible with
JavaScript. Tools to help database managers with design,
replication, management, performance monitoring, and query and
reporting are also in the package.
Sybase SQL Server Professional will be available for Windows
NT and major Unix platforms by the end of the year. Pricing
has not yet been announced.
baze.podataka.220nimi,
-> #215, mmarkovic> 50 MB u 20 sec! 2.5 MB/sec sa obradom...
> (ili ipak ne cita celu tabelu, nego nesto preskace?)
Ne nepreskace, cita svaku promenu vidi da li
je zaduzenje ili odobrenje, deo pocetnog stanja
(nalog broj 1) ili je obican sve sabere u
odgovarajuci zbir i prikaze rezultat.
> Kakve diskove ima to cudo? Vezane u RAID?
Ne, mi smo siromasni :))), diskovi su SCSI II
Pozdrav Milan
baze.podataka.221velicko,
REPLY NA PCPROG.6:windows 4.115
> Hajde napiši ovde reč dve o tome šta je Oracle Power Objects, i
> prednosti i mane u odnosu na konkurenciju.
Nemam vremena da napišem samo reč dve..
So, sorry zbog rasplinjavanja.
Oracle Power Objects je Oraclova vizuelna alatka za
kreiranje aplikacija za rad sa bazama podataka.
Aktuelna verzija 1.0.16 C
Minimalni zahtevi:
za razvoj: 486 8 MB
za izvršavanje: 386 4 MB ( ja ipak ne preporučujem
ispod 486 sa 8 MB )
Na disku zauzima oko 30 MB
Gotova aplikacija se isporučuje uz runtime modul, i
zauzima najmanje 2 disete. Aplikacija se interpretira....
Sastoji se iz 2 komponente, za sada blisko povezane:
- Vizuelnog alata
- baze podataka BLAZE
Vizuelni alat:
_____________
Oracle je pokupio lepe stvari iz Visual Basica i Delphy-ja.
Rad je klasičan. Kreiraju se forme, lepe se komponente.
Nasleđivanje se maximalno koristi gde god je moguće.. ( čak je i to
vizuelno lepo predstavljeno ).
Pisanje jednostavnih efektnih aplikacija je veoma lako.
Primer: Adresar, koji koristi nekoliko tabela u relaciji,
sa pretraživanjima, izveštajima, (lepo izgleda) napisao sam za
2 sata ( + 2 sata šminkanja ). Ništa posebno, osim što je to
bilo pri mom prvom susretu sa OPO alatom. Da, možda treba pomenuti
da je ukucano svega nekoliko linija koda uz neke akcije..
Iza svega stoji Oracle Power Basic (pojačan visual basic).
Kroz sintaksu jezika se vidi da je maximalno prilagođen radu sa
bazama podataka. Postoji execSQL komanda kojom šaljemo SQL upit
bazi podataka, brdo funkcija koje podržavaju data store objekte...
Mane:
Iz OPO-a je nemoguće kreirati sopstvene komponente.
Moguće je nasleđivanje postojećih, i ubacivanje OCX komponenti, ali
sam razvoj "od nule" nije moguć.
Kod se interpretira. Doduše nije spoooro, ali je moglo biti
brže.
Ima dosta bugova. Lično sam naleteo na nekoliko, ali su oni
ipak bili dokumentovani, i laki za prevazilaženje...
Editor u kome se kuca kod programa je loš.
Baza podataka BLAZE
____________________
OPO ima native drajvere za Oracle i Microsoft SQL server.
Za potrebe razvoja uz OPO stiže i osakaćena ORACLE baza, koju je
Oracle nazvao BLAZE. Blaze "guta" sve što bi moglo da se pošalje
i Oracke database serveru, međutim u ovoj verziji na neke poruke
ne reaguje nikakvom akcijom. :( Ne rade STORED PROCEDURES (ali ih
ipak čuva), indeksi rade samo po jednom polju... :((
Prilično nezgodan bug je i to što je nemoguće promeniti
strukturu tabele koja u sebi sadrži podatke. ( SQL insert from
radi )...
Pre razočarenja:
___________________
Ovaj paket u ovoj verziji NEMA preporuku od strane Oracle
korporacije. Ne preporučuju upotrebu OPO-a za rad na većim
projektima i svesni su većine bagova u paketu.
Ovih dana treba da se pojavi nova verzija koja će biti
mnogo jača i stabilnija. Po njima OPO treba da zameni brdo alata
koji stižu uz Oracle. Navodno hoće da izbace Oracle FORMS....
Umesto BLAZE baze isporučivaće ORACLE LITE. koji je
naslednik Personal Oracle paketa.
Bez obzira na ovakav stav Oracla, lično bih se usudio
da manje aplikacije odradim u OPO-u.
Još jednom sorry zbog ovkvog izlaganja...
Pitajte šta vas zanima....
baze.podataka.222bceklic,
Ima li koga ko radi u clairon-u za dos? (mail)
baze.podataka.223sale.car,
-> #222, bceklic Bc> Ima li koga ko radi u clairon-u za dos? (mail)
Obrati se nensky-u da te ubaci u grupu...
Ima nas dosta :)
... Pozdrav, Sale.Car
baze.podataka.224bceklic,
-> #223, sale.car> Bc> Ima li koga ko radi u clairon-u za dos? (mail)
> Obrati se nensky-u da te ubaci u grupu...
> Ima nas dosta :)
Ne radim u clarion-u, treba mi samo nekoliko informacija koje su
bitne za programe na kojima radim.
baze.podataka.225sasab,
Potreban program za hotelijerstvo.
Dragan Petrović, tel. 027/81-610, 81-611
baze.podataka.226river,
-> #225, sasabPotreban program za vođenje sutr-a (samostalno ugostiteljska
trgovinska radnja).
Prednost imaju programi proverenog kvaliteta (bez ikakvih bagova),
koji su već istestirani.
baze.podataka.228whitie,
Za potrebe jednog P.Bilder 4. programa potrebni "rikvest" drajveri za
WFWG. Drajveri za W95 su istog imena po su preorali jedni druge. Radi se
o ODBC drajverima: pbodbc040.dll , pbobbc040.ini i pbodbcm40.dll.
baze.podataka.229coda,
Potreban programer za izradu aplikacije u Visual Basic-u.
Program treba da radi pod Windows-ima, komunicira sa COM
portom, daje graficki prikaz, formira bazu, itd.
ma se coda
baze.podataka.230djale,
Ako neko ima knjigu u izdanju Mikroknjige od Alana Simpsona ACCESS 2
molio bih da mi se javi radi kopiranja iste
Hvala Darko
baze.podataka.231djale,
Narode dali neko zna kako se ACCESS-u radi EXE fajl
Takodje me zanima ako neko ima kakvu dobru knjigu da se
dogovorimo oko kopiranja
HVALA Darko
baze.podataka.232dr.grba,
-> #231, djale>> Narode dali neko zna kako se ACCESS-u radi EXE fajl
Access ne može da napravi EXE fajl. Postoji runtime modul koji se
isporučuje uz Access Developer's Kit, koji nije baš jeftin.
baze.podataka.233madamov,
-> #232, dr.grba> Access ne može da napravi EXE fajl. Postoji runtime modul koji se
> isporučuje uz Access Developer's Kit, koji nije baš jeftin.
A da li postoji neki kompajler za Access? Naime, na Macu imam sličan proizvod
(kada vidim Access na PC-u ne mogu se oteti utisku da su neke fazone pozajmili
od 4D-a) koji se takođe oslanja na runtime, koji se dobija sa uz 4D i
dozvoljeno ga je deliti uz razvijene aplikacije (u ranijim verzijama je svaki
korisnik morao da kupi svoj runtime), ali postoji kompajler koji se posebno
kupuje i skuplji je skoro dvostruko od kompletnog proizvoda za razvoj baza.
Nisam imao prilike da ga lično probam, ali prema tvrdnjama Amerikanaca sa
mailing liste kompajler stvar ubrzava drastično, neke operacije i do nekoliko
hiljada puta. Da ne govorim o prednosti kreiranja nezavisnih aplikacija.
baze.podataka.234dr.grba,
-> #233, madamov>> A da li postoji neki kompajler za Access? Naime, na Macu imam sličan
>> ...
>> mailing liste kompajler stvar ubrzava drastično, neke operacije i do
>> nekoliko hiljada puta. Da ne govorim o prednosti kreiranja nezavisnih
>> aplikacija.
Nije mi poznato da postoji takav kompajler za Access. To, u neku ruku,
ne bi ni imalo mnogo smisla: Access ipak nije zamišljen za takve
namene. To što je (i te kako) moguće napraviti aplikacije koje rade
potpuno kontrolisano, druga je priča. Za pravljenje stand-alone
aplikacija baza, Microsoft u poslednje vreme gura Visual FoxPro.
baze.podataka.235kiklop,
-> #234, dr.grbaA šta fali Visual Basicu?? Native baza VB-a je upravo access. Odlično
se slaže sa njim i omogućava jako jednostavno pisanje stand alone
aplikacija (provereno). E sad što VB ne pravi baš pravi exe program,
to je druga stvar, ali niko nije savršen. :)))
baze.podataka.236dr.grba,
-> #235, kiklop>> A šta fali Visual Basicu?? Native baza VB-a je upravo access. Odlično
>> se slaže sa njim i omogućava jako jednostavno pisanje stand alone
>> aplikacija (provereno).
Pa dobro, o VB nismo pričali. Samo sam hteo da raščistimo neke
stvari o Accessu.
baze.podataka.237peran,
Da li mi neko moze pomoci da mi pod windowsom 95 proradi Oracle 7.1
-verzija za win 3.11.
baze.podataka.238dekik,
-> #237, peran
D?>> Da li mi neko moze pomoci da mi pod windowsom 95 proradi Oracle 7.1
D?>> -verzija za win 3.11.
Da li je moguche da je josh u upotrebi win 3.11 ?!
baze.podataka.239orlic,
Kako instalirati Personal Oracle 7 pod windows 95?
Non stop trazi w32s a on je sadrzan u w95 tako da nece naknadno
da se instalira????
baze.podataka.240madamov,
Integrated Web server highlights new features at a competitive price.
CUPERTINO, CA. March 24, 1997 ACI US, Inc. shipped the 4th Dimension
Version 6 (4D V6) relational database today. Company president and
founder Marylene Delbourg-Delphis states, "With 4D V6, ACI has plotted a
course in three main directions. We have taken a new approach to
Internet/intranet technology, enhanced the developer environment, and
revised the 4th Dimension interface."
4D V6 integrates database technology with Internet capabilities through
its built-in web server, enabling immediate Web data publication simply
by clicking a check box in the Preference dialog. The new version
converts 4D forms to HTML on-the-fly with no need for an external CGI or
additional software. Because of the integrated 4D architecture, a Web
browser becomes just another client to 4D, allowing users to access,
insert, modify and delete data stored in 4D and SQL or ODBC-compliant
databases such as ORACLE, Informix, and Sybase. Additionally, the
optimized 4D Web server architecture guarantees automatic session
maintenance, record locking, transaction management, and data integrity.
4D V6 is an integrated, coherant, 32-bit, cross-platform architecture,
allowing smooth scalability between individual and workgroup
applications. The extensive 4D V6 cross-platform development capabilities
make it a very cost-effective system for development and deployment.
4D V6 enhances the developer environment through new features such as a
world-class debugger, increased speed, memory management and I/O
optimizations, a new graphic interface, and hundreds of new commands.
Other 4D V6 features include triggers and stored procedures,
drag-and-drop support, and an object-based form editor for easy
user-interface creation and straightforward code re-use. 4D V6 also
allows users a hierarchical view of the database structure and easy
access to all 4D objects through 4D Explorer, the elaborate drill-down
browser.
PRICE AND AVAILABILITY
According to Vice President of Sales Bruce Finch, "We took a hard look at
pricing strategies in the marketplace. As a result, ACI US is much more
competitive. Publishing your database on the Web has never been easier or
more affordable." The street price for 4D V6 is $299, including 5
simultaneous Internet connections.
For customers wishing to add more connections, expansion package options
are available. Customers may purchasse 4D V6 through authorized resellers.
ABOUT ACI US, INC.
ACI US, INC. was founded in 1987 as the US publisher of 4th Dimension and
the 4D product line, which has set the relational database standard for
ten years, In 1995, ACI extended 4th Dimension technology to the Windows
platform. ACI US is located at 20883 Stevens Creek Boulevard, Cupertino,
CA 95014; tel 408-252-4444; toll free 800-881-3466; fax 408-252-4829;
<http://www.acius.com>.
baze.podataka.241velicko,
Subj: Oracle Power Objects
Jel neko negde video verziju 2.0 ?
Verzije 1.x imaju strahovite bagove sa BLAZE bazom :(
baze.podataka.242guta,
- novo -
windows\program\*.*
------------------
map97.zip 184k ű Access97 Database Documentor Add-In: Access dokumentacija
Database Documentor Add-In Access 97' 2.02
------------------------------------------
Updated version now creates cross references of tables and queries in
forms, queries, reports, and modules. This add-in documents tables,
queries, forms, reports, and modules, including code behind forms and
reports. All controls on forms and reports are fully documented. There are
several predefined reports and the user can open the documentor MDB that
is created to define new queries and reports.
Your database is not modified in any way. The add-in creates an MDB for
each database you document.
baze.podataka.243madamov,
Subject: Announcing 4D Server V6
From: "Finch, Bruce" <finch@acius.com>
Date: 14 May 1997 17:30:47 -0700
ACI ANNOUNCES 4D SERVER Version 6!!
The client/server solution combining 4th Dimension and more
On May 28, 1997, ACI US will ship 4D Server Version 6, the newest upgrade to
the outstanding 4D product line. 4D Server combines the user-focused power of
4D with the strength of a client/server and Web Server architecture. Whether
you are a database user or a database developer, 4D Server is the superior
solution for designing, developing, and deploying within a workgroup,
Internet, or Intranet environment.
This unique product offers the user an integrated back-end server tool as well
as an Internet CGI toolĐno middleware is required for your client/server
connection or your Internet connection. The 4D Server multi-threaded
architecture delivers a wide range of integrated features and services, such
as triggers and stored procedures, a Web server, a data server, a network
protocol manager, and also serves as an application server. Coupled with all
the phenomenal 4th Dimension Version 6 (4D V6) features, 4D Server is a
cost-effective solution at a remarkable price. The estimated street price for
4D Server Version 6 is $699, and includes two 4D Client user licenses and five
Internet connections. 4D Server Version 6 upgrade prices begin at $279 for
version 1.5x.
If you already own an earlier version of 4D Server and additional 4D Client
user license expansion packs, you will want to upgrade immediately to 4D
Server V6 and 4D Client V6 to take advantage of their outstanding features. 4D
Client combines the efficiency of rapid application development (RAD) with
multi-user capabilities. As a database development tool, 4D Client integrates
the 4D interface, debugger, BLOBs, and user tools. As a cross-platform tool,
4D Client provides a multi-platform interface, auto switching, form wizards,
and much more. 4D Client user license expansion pack upgrades begin at $49 for
a single-user expansion pack. For additional pricing information, please see
enclosed order form.
All 4D documentation is available on-line, including the 4D Server Reference
Manual. However, if you prefer, you may purchase a complete 4th Dimension
printed documentation set for $99. Enclosed in your software upgrade package
you will find a 4D Server Reference Manual coupon. When the printed 4D Server
Reference manual becomes available, you have the option of redeeming the
coupon to receive the printed manual.
If you are a registered ACI US Partner or purchasing 4D Server and 4D Client
upgrades, you may place your order with the ACI US Customer Service Department
at 408-252-4444 x252. ACI US appreciates your continued support.
Bruce Finch
baze.podataka.244dekik,
Nedavno sam nabavio Telefonski Imenik SRJ koji drzi telefone "spakovane" u
.mdb formatu (MS Access 7.0). Problem je u tome sto u programu nigde nema
opcije za stampanje pa me interesuje da li se moze nekim programom pogledati
takav fajl i odstampati ?!
Unapred Hvala!
baze.podataka.245kenza,
-> #244, dekik(;> opcije za stampanje pa me interesuje da li se moze nekim programom
(;> pogledati takav fajl i odstampati ?!
Pa naravno da moze - Access-om :) Uostalom, ako nemas Access mozes da
probas da importujes samu bazu u neki drugi format pa onda da stampas.
baze.podataka.246firus,
Izvinjavam se što će se ova (ista) poruka naći u par tema
ove konferencije, ali pošto mi je stvar vrlo bitna želim da se
osiguram da će je svi videti. Moj problem je u sledećem:
Imam jedan .DBF fajl sa pripadajućim .NSX i .SMT fajlovima.
To je jako lepo, ali ja nisam Clipper programer (još manje umem da
se petljam sa SIx drajverom) tako da mi je potrebna pomoć oko
konverzije narečenih fajlova u (poželjno) Fox format, znači: .SMT
u .FPT, .NSX u .IDX (ili .CDX, nemam pojma kakvi su indeksi u .NSX
formatu), a čak je i struktura .DBF fajla drugačija od standardne
(pod ovim posmatram dBASE III+ .DBF), znači treba i to da
konvertujem.
Ako ništa drugo, biće mi dovoljan i opis narečenih SIx-ovih
formata pa ću lako da napišem konverter.
P.S. Eh, ah, da, stvar je prilično HITNA !!! Priskočio sam u pomoć
jednom prijatelju kome je neki tip pre par godina napisao jednu
aplikacijicu ne bi li ovaj automatizovao poslovanje, medjutim,
tip nije ostavio ni sors, niti ikakvu dokumentaciju, dok je,
sa druge strane, moj prijatelj koji, UBR, sa kompjuterima nema
blage veze - zna da koristi taj program i ništa više, napravio
s*anje i razbucao disk (kako, ne pitajte mene). Sad je njemu
potrebno nešto što mu vrši posao. Pokušao sam na raznim
stranama, ali mrka kapa. Računam na vašu kolegijalnu
solidarnost. Unapred hvala ...
baze.podataka.247mmarkovic,
-> #246, firus> Izvinjavam se što će se ova (ista) poruka naći u par tema
> ove konferencije, ali pošto mi je stvar vrlo bitna želim da se
> osiguram da će je svi videti. Moj problem je u sledećem:
Mislim da bi bilo dosta u temi clipper ili razno...
> Ako ništa drugo, biće mi dovoljan i opis narečenih SIx-ovih
> formata pa ću lako da napišem konverter.
Mislim da ovo nije nigde opisano, a srećom, nema ni potrebe.
U svakom slučaju, ne znam format, a mislim da i ne treba da znam.
Ovo programče bi završilo posao (može li neko da ti ga iskompajlira?
UL mi je očajan, a rezultujući EXE bi bio prilično veliki)
-------------------------
// CONVERT.PRG
#include "sixnsx2.ch"
proc main( f1, f2 )
use (f1) via "SIXNSX"
copy to (f2) via "SIXCDX"
return
-------------------------
Upotreba: CONVERT stara nova
gde je STARA (dbf/smt - SIX) a nova dbf/fpt - FOX
-------------------------------------------------
Uz poruku je SIX primer za obrnut problem
Sa indeksima ne bi trebalo da se petljaš, valjda taj program
ima reindeksiranje...
fpt2smt.prgbaze.podataka.248bokir,
-> #247, mmarkovic> Ovo programče bi završilo posao (može li neko da ti ga iskompajlira?
Evo ga, iskompajlirano...
convert.zipbaze.podataka.249bokir,
-> #248, bokir> Evo ga, iskompajlirano...
Ups...nisam ulinkovao i SIXCDX, so, evo ga ponovo...
convert.zipbaze.podataka.250firus,
-> #247, mmarkovic>> Izvinjavam se što će se ova (ista) poruka naći u par tema
>> ove konferencije, ali pošto mi je stvar vrlo bitna želim da se
>> osiguram da će je svi videti. Moj problem je u sledećem:
>
> Mislim da bi bilo dosta u temi clipper ili razno...
A odgovor na poruku mi stiže u temi baze.podataka ?! ;)
Šalu na stranu, neizmerno sam zahvalan na odgovoru,
a ako uzmem u obzir i brzinu kojom sam dobio odgovor onda dugujem
ne jednu već dve ture pića (prvom prilikom kada skočim do Niša
ili kada ti dodješ u BGD, ili, nekim čudom zabasaš u Veliko
Gradište.
Takodje, koristim priliku da se zahvalim i bokiru koji je
kompajlirao sors i poštedeo me muka nabavke Clipper-a i SIx-a ...
(I ovde se piće podrazumeva B)
P.S. Obrisana je poruka iz ostale tri teme. Za ovo meni moderator
dodje turu pića B)
baze.podataka.251mmarkovic,
-> #250, firus> > Mislim da bi bilo dosta u temi clipper ili razno...
>
> A odgovor na poruku mi stiže u temi baze.podataka ?! ;)
I ja primetih, nego kada sam radio PASS2 kroz poruke,
prvo naleteh na tu poruku, ode ALT-R, i tako... :)))))
> Šalu na stranu, neizmerno sam zahvalan na odgovoru,
> a ako uzmem u obzir i brzinu kojom sam dobio odgovor onda dugujem
> ne jednu već dve ture pića (prvom prilikom kada skočim do Niša
> ili kada ti dodješ u BGD, ili, nekim čudom zabasaš u Veliko Gradište.
Ix, gde ćemo da pijemo i ko časti, manje je bitno! Nego, da li si
isplivao?
Ako možemo još nekako da pomognemo, kaži.
NSX indeksi, a i CDX, mogu u sebi da sadrže više ključeva, a mogu
i samo jedan. Pogledaj, recimo LIST-om...
A brzinom, od tvoje poruke do bokirovog EXE-a sam i sam bio
iznenađen... Dobra stvar ovaj Sezam, ponekad...
Nego, kad pomenuh indekse, jel' ti beše onaj firus što nam je obećao
priču o B-stablima? Beše i neki ex-micotakis ?!? ;)
baze.podataka.252bokir,
-> #250, firus> Takodje, koristim priliku da se zahvalim i bokiru koji je
> kompajlirao sors i poštedeo me muka nabavke Clipper-a i SIx-a ...
> (I ovde se piće podrazumeva B)
No problem, samo ako radi posao...
Jesi li uspeo da središ sve to?
baze.podataka.253firus,
-> #251, mmarkovic> Ix, gde ćemo da pijemo i ko časti, manje je bitno! Nego, da li
> si isplivao?
Isplivao, nego šta, imao sam dobre instruktore plivanja
a i spasioce na plaži B))
> NSX indeksi, a i CDX, mogu u sebi da sadrže više ključeva, a
> mogu i samo jedan. Pogledaj, recimo LIST-om...
Za CDX znam, pošto sam intalirao Fox i čitao help
(ja se inače ne bavim bazama podataka), ali NSX su mi,
očigledno bili nepoznanica. Smatrao sam da će mi biti lakše da
promuntam strukturu datoteka, uspostavljenih relacija itd.,
ako imam i očuvane indeksne fajlove. No, BKB, uz pomoć NU sam
prilično lako skontao kako su datoteke (da, da, ima ih puuno)
indeksirane.
> Nego, kad pomenuh indekse, jel' ti beše onaj firus što nam je
> obećao priču o B-stablima? Beše i neki ex-micotakis ?!? ;)
Ex-micotakis tj. Aca je jedno vreme bio "podstanar" na
mome user-u, ali je posle par meseci dobio šut-kartu jer je sve
manje poštovao dogovor i ponašao se kao da je user (ekskluzivno)
njegov (imao sam i ignore listu sa desetak imena, ponekad bi mi
ostalo svega par minuta dnevno ...)
Priču o B-stablima sam stvarno ja obećao, medjutim
zaboravilo se, ali greška će biti ispravljena (u dogledno vreme,
trenutno mi je u toku junski ispitni rok).
baze.podataka.254firus,
-> #252, bokir>> Takodje, koristim priliku da se zahvalim i bokiru koji je
>> kompajlirao sors i poštedeo me muka nabavke Clipper-a i SIx-a
>> ... (I ovde se piće podrazumeva B)
>
> No problem, samo ako radi posao...
> Jesi li uspeo da središ sve to?
Datoteke su konvertovatne, na aplikacijici se radi,
sve je pod kontrolom.
baze.podataka.255mmarkovic,
-> #253, firus> Priču o B-stablima sam stvarno ja obećao, medjutim
> zaboravilo se, ali greška će biti ispravljena (u dogledno vreme,
> trenutno mi je u toku junski ispitni rok).
OK. Čekamo. Srećno, šteta da i tu ne možemo da pomognemo... ;)
baze.podataka.256kum.djole,
Treba mi "nekakav" DOS program koji podržava (i obrađuje) veliku bazu
podataka tipa: unesem podatke o firmi, firma ta i ta bavi se tim i tim,
adresa, telefon, itd.. eventualno neki 'note' o zapažanjima, itd itd..
Elem, nije za mene, a i pomalo mi je laički objašnjeno šta treba..
Hvala unapred. :)
baze.podataka.257popovics,
-> #256, kum.djole
>>Treba mi "nekakav" DOS program koji podržava (i obrađuje) veliku
>>bazu
>>podataka tipa: unesem podatke o firmi, firma ta i ta bavi se tim i
>>tim,
>>adresa, telefon, itd.. eventualno neki 'note' o zapažanjima, itd
>>itd..
>>Elem, nije za mene, a i pomalo mi je laički objašnjeno šta treba..
>>Hvala unapred. :)
Đole, za takav program neznam (jer se nikada nisam bavio bazama
podataka), ali moram da ti kažem da si promašio temu, uostalom,
zašto ne skineš spisak programa iz Sezamovih direktorijuma i
pogledaš šta tu ima - možda se i nađe nešto tako...
baze.podataka.258kenza,
Hi!
Jel ima zainteresovanih za osnivanje grupe MS Access? Ako ima,
prijave kod mene u mail :)
baze.podataka.259sjocic,
Imam neku bazu podataka (tel. imenik) u *.mdb formatu.
Koji programi koriste ovaj format baze - Paradox ?
Da li je moguće napraviti poseban program koji bi baratao sa
ovom bazom, ako mi nije poznat format zapisa, tj. da li je moguće
nekako otkriti koji je format zapisa ?
baze.podataka.260kenza,
-> #259, sjocic>> Koji programi koriste ovaj format baze - Paradox ?
Microsoft Access :)
>> ovom bazom, ako mi nije poznat format zapisa, tj. da li je moguce
>> nekako otkriti koji je format zapisa ?
Najlakse je Access-om da otvoris tabelu koja te zanima(unutar
baze) i pogledas njen format :) Sto se programa tice, mogu da je
koriste i VB i Delphi preko svojih DB Engine-a. Medjutim, ako to
vec radis na taj nacin, a ne iz Access-a, onda je bolje da
napravis svoj format tabele i resis problem... :)
Poz.
baze.podataka.261sjocic,
-> #260, kenza-> Najlakse je Access-om da otvoris tabelu koja te zanima(unutar
-> baze) i pogledas njen format :) Sto se programa tice, mogu da je
-> koriste i VB i Delphi preko svojih DB Engine-a. Medjutim, ako to
-> vec radis na taj nacin, a ne iz Access-a, onda je bolje da
-> napravis svoj format tabele i resis problem... :)
Hvala na odgovoru, instalirao sam Access i stvari su postale mnogo
jasnije. Nemam nikakva iskustva u programiranju pod Win, a pogotovu
ne sa bazama, ali imam nameru da uz pomoc neke literature napravim
nesto elementarno - samo za pregled rekorda i pretrazivanje po
razlicitim kriterijumima (tel, adresa, ime i sl.)
Uzgred, kako se Access snalazi sa malo vecim bazama - reda 10-70Mb?
baze.podataka.262kenza,
-> #261, sjocic>> Uzgred, kako se Access snalazi sa malo vecim bazama - reda 10-70Mb?
Pravo da ti kazem, ne znam... :( Moja najveca baza je dostigla
oko 800k u 400 slogova. Mislim da ne bi trebalo da bude problema,
jer ipak je to jedan od najozbiljnijih DB programa. :)
Poz.
baze.podataka.263dr.grba,
-> #262, kenza>>>> Uzgred, kako se Access snalazi sa malo vecim bazama - reda 10-70Mb?
>>
>> Pravo da ti kazem, ne znam... :( Moja najveca baza je dostigla
>> oko 800k u 400 slogova. Mislim da ne bi trebalo da bude problema,
Studije slučaja pokazuju da je Access carski na manjim bazama,
ne više od 80-100.000 slogova. Naravno, ovo treba uzeti sa dozom
rezerve, jer sirova snaga mora da ustupi mesto projektivnom pristupu
i planiranju baze.
Ono gde je Access odličan jeste integracija raznorodnih izvora
podataka na klijent-strani. Teško da tu postoji bolji 'value for
money', kako kažu Ameri. Mada, pojavom novih proizvoda Oraclea,
SyBasea i njima sličnih tu dolazi do promene odnosa snaga na
strani klijenta.
>> jer ipak je to jedan od najozbiljnijih DB programa. :)
E, ovde stvarno treba smeško (:
baze.podataka.264kenza,
U planu je otvaranje grupe MS Access. Molim prijave
zainteresovanih na mail ;)
baze.podataka.265netcomm,
Otvorena je grupa MSACCESS, javljajte se
baze.podataka.266superhik,
Hey!
Ćale mi radi u MS Accessu i nije baš neki mag u tome ali je uspeo da
napravi neko programče koje sada treba da spremi ya instalaciju na
drugim mašinama koje nemaju MS Access, zna li neko kako se to radi i
može li se to uopšte
Txanks 10x!
baze.podataka.267kenza,
-> #266, superhik>> drugim masinama koje nemaju MS Access, zna li neko kako se to radi i
>> moze li se to uopste
Svakako da moze... samo ne rece o kojem je Access-u rec? Ako je
2.0 onda ce instalacion verzija biti 5 ili vise disketa a ako je
nesto novije od dvojke, onda... ;> Recimo samo da bi bilo bolje
da instalira ceo Access ;) LM, paket koji mu treba je Access
Developer's Toolkit za odgovarajucu verziju Access-a(ako je
dvojka 4 diskete, mozes da ih dobijes od mene, dok za novi
Access ADT zauzima ceo jedan CD koji ja nemam ali pirati
najverovatnije da)
Poz.
baze.podataka.268lazzaro,
Da li neko zna gde bi mogao da nabavim neku dobru literaturu za
oracle7 i jos ako neko zna koja je verzija oracle7 moguca da radi
na pc-u.
Pozdrav :)
baze.podataka.269ralex,
Molio bi ako neko zna da li postoji neko uputstvo za Clarion 2.0 za
Windows na srpskom ili engleskom i da li ono moze da se nadje i gde
Unapred se zahvaljujem svima koji mi pomognu da to uputstvo
pronadjem
Ralex
baze.podataka.270sjocic,
Kako 'prepraviti' DBF fajl ?
Evo u cemu je problem: U dbf fajlu nalaze se ulazi i izlazi sa
datumima za sve artikle iz magacina jedne firme.
Potrebno je DBF fajl 'procistiti' svih podataka osim poslednjeg,
koji sadrzi trenutno stanje za dati artikl i datum njegove poslednje
promene.
Postoji li neki utility koji bi ovo mogao da izvede, tj. kako ovo uraditi?
baze.podataka.271rdejan,
-> #270, sjocic>> Potrebno je DBF fajl 'procistiti' svih podataka osim poslednjeg,
>> koji sadrzi trenutno stanje za dati artikl i datum njegove poslednje
>> promene.
Možda ne baš najefikasnije, ali zasigurno najbrže - MS Excel.
Otvara .dbf, snima .dbf i još puno toga za samo $9,95... :)
Pozdrav, Dejan
baze.podataka.272vvaske,
Ima li ne ko (ili zna gde ima) skup VBX-ova
"Data Vidgets". Proizvodjac "Sheridan Software System"
Ekvivalent DBGrid-u i ostalima iz VB-4.0
Hvala
vvaske
baze.podataka.273guta,
-> #272, vvaske#> Ima li ne ko (ili zna gde ima) skup VBX-ova
#> "Data Vidgets". Proizvodjac "Sheridan Software System"
#> Ekvivalent DBGrid-u i ostalima iz VB-4.0
Pošto je u pitanju komercijalni paket kontrola, sumnjam da se bilo gde
može naći bez da se plati licenca. Naravno, kod pirata je svašta moguće,
ali u to se ne bih upuštao.
baze.podataka.274guta,
Microsoft Announces
Visual FoxPro 6.0
Microsoft Transaction Server Support
Improves Scalability; New Productivity
Features Jump Start Development of Visual FoxPro
ORLANDO, Fla. - May 18, 1998 - Today at Visual
FoxPro DevCon 98, Microsoft Corp. announced the
Microsoftr Visual FoxPror database development
system version 6.0. The new version will enable
developers to build high-performance scalable database
solutions and components. The 1,600 DevCon attendees
saw demos of enhanced productivity, ease of use and
enterprise development features in the new version of
Visual FoxPro.
A member of the Visual Studio™ development
system family, the industry's leading development tools
suite, Visual FoxPro 6.0 enables developers to take
advantage of the latest advances in the Windowsr and
Windows NTr operating systems . Scheduled for
widespread availability later this summer, Visual
FoxPro 6.0 is designed to give more than 500,000
developers using Visual FoxPro a more efficient and
powerful way to build data-centric, multitier
client/server and Web-based applications and to help
ensure that new and existing applications are year
2000-compliant.
"Visual FoxPro is essential to our OmniTRACS mobile
information software product development," said
Michael Harlan, manager, software applications
engineering of the OmniTRACS division at
QUALCOMM Inc. "We believe Visual FoxPro 6.0 will
enable our team to be more productive and will provide
our customers with powerful and scalable management
information solutions while improving our
time-to-market."
Builds High-Performance Scalable Components
Visual FoxPro 6.0 is enhanced to build data-intensive
components for the middle tier of three-tier
applications.
New support for Microsoft Transaction Server (MTS)
will allow developers to manage and scale components
to hundreds of users and provide cross-component
transactions. MTS support, along with enhanced support
for Active Server Pages and Internet Information Server
(IIS), will let developers build database and
electronic-commerce applications that take full
advantage of the World Wide Web.
"Visual FoxPro, combined with the other tools in Visual
Studio, is the best way for developers who use Visual
FoxPro to move to a three-tier architecture for
enterprise development," said Paul Gross, vice president of
the tools group at Microsoft. "The advances in the new
version will make development easier without
sacrificing the traditional strengths of FoxPro, like an
incredibly fast engine and great data management. Today
you see more and more multitier development with
different tools, languages and backends like Microsoft
SQL Server™ and Oracle 8. Visual FoxPro 6.0 is a
perfect tool for this type of environment."
Year 2000-Compliant Applications
Visual FoxPro has always supported four-year date
fields, but with Visual FoxPro 6.0, Microsoft has
introduced a strict date format to prevent ambiguous
dates and help ensure that new and existing Visual
FoxPro-based applications are year 2000-compliant. The
new version uses a strict date format of yyyy/mm/dd;
this format prevents ambiguous dates like 10/11/12,
which could represent different dates in different
countries. Developers can take existing applications,
built with any previous version of Visual FoxPro, and
recompile them in Visual FoxPro 6.0 to identify
noncompliant dates.
More Productive and Easier to Learn
Visual FoxPro 6.0 will ship with an Application Wizard
and Application Builder to assist developers in creating
an object-oriented framework for jump-starting
development. Also, included in Visual FoxPro will be a
set of new Foundation Classes containing over 100
prebuilt reusable classes that provide common functions
to many applications.
To improve testing and debugging, Microsoft added a
Coverage Profiler that checks and identifies which lines
of code are being run and how long it takes for each line
to execute. New support for ActiveXr Documents
allows developers to migrate existing forms and
applications quickly and easily to the Web. Visual
FoxPro 6.0 will also come with a new Web-publishing
wizard.
Visual FoxPro 6.0 to Ship in Visual Studio 6.0
Visual FoxPro will be available as a standalone product
as well as included in Visual Studio 6.0, the
comprehensive suite of Microsoft developer tools for
Windows and the Web. Visual FoxPro 6.0 and Visual
Studio 6.0 are scheduled to be available during the
second half of 1998. Additional information on Visual
FoxPro can be found at http://www.microsoft.com/vfoxpro/
baze.podataka.275guta,
Visual FoxPro 6.0 Live Chat Part 1
----------------------------------
U nastavku poruke se nalazi transkript chat-a o beta verziji
Visual FoxPro-a 6.0
U razgovoru su učestvovali ljudi iz VFoxPro razvojnog tima, pa među
pitanjima i odgovorima možete pronaći dosta podataka iz tips & tricks
sekcije.
------------------------------
MSDN Online Chat
Chat about Visual FoxPro 6.0
Live from the Microsoft Visual FoxPro Developers
Conference
May 19, 1998
Orlando, Florida
Microsoft participants in this MSDN chat included
Visual FoxPro product manager Robert Green, host Sondra
Webber of MSDN, and six other members of the
Visual FoxPro team: Susan Graham, Randy Brown, Ricardo
Wenger, Doug Shepard, Allison Koeneke, and Tom Cooper.
Host sondra_MS says:
Hello, please stick around until 11 am PST for MSDN
Online's chat-Live from the Microsoft Visual FoxPro
Developer's Conference.
RobertGreen_MS says:
Hello everyone. We are live at DevCon 98 from
Orlando.
Q: Will Tahoe /Microsoft's internal code name for
Visual FoxPro 6.0/ have better support for ActiveX
components?
RobertGreen_MS says:
A: Yes. Incrementally better in Visual FoxPro, and
there is increased awareness from the control vendors
that they need to test better with Visual FoxPro.
Q: Robert, are you still scheduled for Waltham next
week?
RobertGreen_MS says:
A: Yes. I will be at your user group on Tuesday at 7.
The meeting is in the MS office in Waltham. Everyone in the
area is welcome.
Q: Last week Microsoft announced retirement of Visual
FoxPro 3.0 exam.
RobertGreen_MS says:
A: There will be a new 5 day MOC course for Visual
FoxPro 6.0 and also a new MCP exam for Visual FoxPro 6.0.
These will appear shortly after the product ships.
Q. Coolbar support?
Host AllisonK_MS says:
A: Not natively in Visual FoxPro but there are OCXs
that will give you this functionality.
Q: My first question is... when is this going to
start?
RobertGreen_MS says:
A: We have started. We are live at the Visual FoxPro
DevCon98 in Orlando. The big news of course is that we
announced and showed Visual FoxPro 6.0.
Q. Will Visual FoxPro 6.0 release the updated version
of the ODBC driver? And will it support ADO?
AllisonK_MS says:
A. The currently shipping ODBC driver works with ADO
already but we also plan on updating the ODBC driver in
the future.
Q: Will Visual FoxPro 6.0 release the updated version
of the ODBC driver? And will it support ADO?
RobertGreen_MS says:
A: We will have an incremental update to the ODBC
driver when we ship. We have complete programmatic support
for ADO in Visual FoxPro 6.0 (and 5.0) for that matter.
Q: IS there a ship date for Visual FoxPro 6.0 yet?
RobertGreen_MS says:
A: Later in the summer.
Q: Does Visual FoxPro 6.0 support security on the
DBC?
RobertGreen_MS says:
A: Nope.
Q: Does Visual FoxPro 6.0 support security on the
DBC?
RobertGreen_MS says:
A: Nope.
Q: Have the Tahoe beta testers been released from the
Tahoe part of their NDAs yet?
RobertGreen_MS says:
A: Yes.
Q: What about DCOM support?
RobertGreen_MS says:
A: We have had that since 5.0. What exactly are you
looking for Tom?
Q: What about a prerelease of Tahoe like you've done
for InterDev?
RobertGreen_MS says:
A: We have pre-released to 1600 of our best customers
here at DevCon!
Q: If the testers have been released from NDA, the
beta is over?
RobertGreen_MS says:
A: No, that is not true! For example, both VJ and VI
are also totally public but we are all still in beta.
We will release later in the summer, but we are still
working on the product.
Q. When is the next Visual FoxPro DevCon?
Host AllisonK_MS says:
A. June 1999 in Palm Springs
Q. Will the update to the ODBC Driver support SQL
commands greater than 255 characters?
Host AllisonK_MS says:
A. We are considering this and other features for our
next release.
Q: I'm not seeing any answers in the top window. How
come?
SusanG_MS_ says:
A: You will shortly.
transcriptor says:
MSDN Online is the one place you should look for
information on all of Microsoft's developer resources.
Visit us at http://www.microsoft.com/msdn/ for
headline news, product information, features, and more.
Q: Do Visual FoxPro 6.0 enhancements push it to the
front of the Visual Studio pack in regards to RAD/OOP
development tools?
Host AllisonK_MS says:
A: Each product has specific RAD and OOP features
that make it a compelling tool for its users.
Host Dougsh_MS says:
GarrettFitzgerald_ says:
RobertGreen: have the Tahoe beta testers been
released from the Tahoe part of their NDAs yet?
Answer from RobertGreen_MS_ms:
The beta testers have been released from their NDA,
but we are still in beta.
Host Dougsh_MS says:
Paul_Rec_ says:
Does Visual FoxPro 6.0 have the equivalent of an
AddressOf operator?
Answer from AllisonK_MS_ms:
No. Is this something that you would like to see in
future versions?
Host Dougsh_MS says:
FredLepow_ says:
I have found no easy way to print forms and code
using Visual FoxPro 5.0. Is there a way? Will Visual FoxPro
6.0 have this feature (like VB PrintAll feature)?
Answer from SusanG_MS_ms:
Not intrinsically. But I understand there is some
shareware that will handle it for you. Check on the
newsgroups for it.
Host Dougsh_MS says:
dwilkerson_ says:
Will the Visual FoxPro 6.0 DBC support data access
triggers?
Answer from ricardow_ms_ms:
Can you be more specific in your question?
Host Dougsh_MS says:
FredBert_ says:
Security on FoxPro tables has been requested since
1.02. Will security on tables ever be added?
Answer from AllisonK_MS_ms:
Most likely not. If you would like security we
suggest moving your data to SQL Server.
Host Dougsh_MS says:
Paul_Rec_ says:
What are the improvements to the Report Writer in
Visual FoxPro 6.0?
Answer from SusanG_MS_ms:
The major improvement is that you can PREVIEW into a
top level form. And of course, there are some bug fixes.
Host Dougsh_MS says:
GLongtin_ says:
OLEDB provider for Visual FoxPro dbc? Any support for
record sets within Visual FoxPro 6.0?
Answer from RobertGreen_MS_ms:
OLEDB provider for Visual FoxPro is under study and a
very good idea. Support for ADO is already in there
programmatically.
Host Dougsh_MS says:
Puck_ says:
What about a prerelease of Tahoe like you've done for
InterDev?
Answer from RobertGreen_MS_ms:
We just did a prerelease version for 1600 of our
favorite customers here at DevCon! <vbg>
Host Dougsh_MS says:
Kendall_ says:
What is Visual FoxPro 6.0's greatest new feature?
Answer from AllisonK_MS_ms:
We have added many features, from Access and Assign
methods to new language features, to an Application
Framework with many foundation classes to server
enhancements and much more. It would be difficult to
say which.
Host Dougsh_MS says:
yournamehere_ says:
When is Visual FoxPro 6.0 going to be released
through MSDN?
Answer from SusanG_MS_ms:
Visual FoxPro goes with Visual Studio when it goes to
MSDN beta.
Host Dougsh_MS says:
Puck_ says:
Q: If the testers have been released from NDA, the
beta is over?
Answer from RobertGreen_MS_ms:
No. We are still working on the product. We will
release later in the summer.
Host Dougsh_MS says:
Puck_ says:
Have the UI controls been updated for FULL Win95 look
and feel?
Answer from AllisonK_MS_ms:
Can you be specific about what you are looking for?
We updated the controls extensively in Visual FoxPro 5.0
for full Win95 look and feel.
Host Dougsh_MS says:
Gerry_Schmitz_ says:
Hi Robert Green. Q: Is the Visual FoxPro team doing
anything to improve Visual FoxPro UI performance (in Visual
FoxPro 6.0 or later)? Compared to FPW, VB, etc. UI refresh
in Visual FoxPro is relatively slow (and I can't
find a reason) since Windows API calls (like TEXTOUT)
** from a Visual FoxPro pgm ** do much better than native
Visual FoxPro .Refresh or .Draw. Comments please!!
Answer from AllisonK_MS_ms:
We have done some selected UI performance
improvements throughout the product.
Host RobertGreen_MS says:
We are having technical difficulties on our end here.
Please bear with us while we get it straightened out.
Host RobertGreen_MS says:
We are live at Visual FoxPro DevCon in Orlando. We
are enjoying the warm weather and the 1600 attendees
getting their first look at Visual FoxPro 6.0.
We are currently experiencing technical difficulties.
Please stand by.
Host Susan_MS says:
Bill_Anderson_ says:
Now for a really important question-any Easter Eggs
in Tahoe? For that matter, how about Visual FoxPro 5.0?
Answer from ricardow_ms_ms:
Yes. Keep looking!!!!
Host Susan_MS says:
Paul_Rec_ says:
When is the next Visual FoxPro DevCon?
Answer from RobertGreen_MS_ms:
June 6-10, 1999 in Palm Springs, CA. (Notice that we
are adding a day to the conference.)
Host Susan_MS says:
FredBert_ says:
Has the 2 gig limit on tables been lifted?
Answer from AllisonK_MS_ms:
The 2 gig limit has not been lifted in Visual FoxPro
6.0.
Host Susan_MS says:
JohnKoziol_ says:
Do Visual FoxPro 6.0 enhancements push it to the
front of the Visual Studio pack in regards to RAD/OOP
development tools?
Answer from RobertGreen_MS_ms:
Well, I wouldn't say we are in the front, but we have
certainly made some pretty impressive progress in the
last couple of releases. We certainly think that all the
Visual Studio tools are great tools, each with their own
strengths.
Host Susan_MS says:
Rodolfo_ says:
Why doesn't menu and report are native classes in
Visual FoxPro 6.0?
Answer from SusanG_MS_ms:
There is no easy answer to that, except that other
features have taken a higher priority.
Host Susan_MS says:
Ron_ says:
Is there a public or MSDN list of new
features/enhancements for 6?
Answer from RobertGreen_MS_ms:
We will be releasing this type of information closer
to when we ship later in the summer.
Host Susan_MS says:
Randyp_ says:
Is it possible for UG Leaders to get Visual FoxPro
6.0 betas for members?
Answer from RobertGreen_MS_ms:
We will be sending user groups a couple of copies of
the beta for them to raffle off to their members.
But we won't be giving out unlimited copies.
Host Susan_MS says:
DavidA_ says:
Where can I find details on the "100 new classes?"
Answer from RobertGreen_MS_ms:
They are fully documented in the product. So, unless
you have the beta, you will have to wait until we ship
Visual FoxPro 6.0 for full details on all of them.
Host Susan_MS says:
Greg_ says:
Has Visual Basic been integrated into Visual FoxPro
as a macro language?
Answer from AllisonK_MS_ms:
Not for Visual FoxPro 6.0.
Host Susan_MS says:
TomDeMay_ says:
Already ask, haven't seen an answer, Callbacks, hWnd
Property and what about structures?
Answer from AllisonK_MS_ms:
Our native controls are not windowed and therefore do
not expose the hWnd. You can get the hWnd of our forms,
however. We do not support structures natively in the
Visual FoxPro language.
Host Susan_MS says:
Warren_ says:
What will the upgrade path be to Visual Studio?
Answer from RobertGreen_MS_ms:
Pretty similar to what it has always been. If you own
a previous version of one of the tools in VS, then you
get a discount for upgrading to it.
Host Susan_MS says:
bwalter_ says:
Is the Visual FoxPro 6.0 Beta going to be available
through any means other than attending the 1998 DevCon?
MSDN or Solution Provider?
Answer from ricardow_ms_ms:
All MS betas are available through MSDN universal.
Host sondra_MS says:
This is an MSDN Online chat, and we are discussing
Microsoft Visual FoxPro. Questions, comments and
suggestions are welcome.
Host Susan_MS says:
dwilkerson_ says:
Will MS increase its marketing strategy for Visual
FoxPro?
Answer from RobertGreen_MS_ms:
We are constantly working as hard as we can to spread
the good word about Visual FoxPro and the role it
plays in Visual Studio. We expect the release of
6.0 later in the summer will help a lot.
Host Susan_MS says:
jsmock_ says:
Will version 6.0 address the many significant bugs
remaining in the current release?
Answer from AllisonK_MS_ms:
We've addressed the bugs that we know about. If you
have specific issues, please make sure you report them
to us.
Host Susan_MS says:
GarrettFitzgerald_ says:
Is the next DevCon most likely going to be a
between-release conference, like last year's?
Answer from RobertGreen_MS_ms:
Oh yes! We are going to ship Visual FoxPro 6.0 later
in the summer, so a DevCon in June 1999 will
definitely still be a 6.0 conference. However, we have
some great ideas on how to improve the conference and
make sure that the content is fresh and new. We hope to
see you there!
Host Susan_MS says:
abgame_ says:
I really do appreciate the improvements made in
version 6.0, from speed to the ease of working on the web.
Curious what we can expect in the future?
Answer from AllisonK_MS_ms:
Some things under consideration: tighter integration
with ADO, such as ADO-type views, OLE-DB provider,
continued improvements to Visual FoxPro components,
more integration with Visual Studio, both at design-time
and run-time...
Host Susan_MS says:
TomDeMay_ says:
I'm seeing a lot of "no's" to our questions. Can you
tell us what Visual FoxPro 6.0 has that would make it worth
my while?
Answer from SusanG_MS_ms:
It's difficult to say what would be worth your while
in 6.0. It depends on what you are doing with Visual FoxPro.
But there are many new features, language enhancements,
Web support, etc.
Host Susan_MS says:
Rodolfo_ says:
Again: Does not make more sense if MS put Visual
FoxPro 6.0 papers on Visual FoxPro site before this on line
chat?
Answer from RobertGreen_MS_ms:
We are not going to be putting any 6.0 papers on the
Web site until much closer to shipping, which is later
in the summer. But once we ship, there will be
a lot of new stuff on our web site.
Host Susan_MS says:
PRobinshaw_ says:
I've heard of 100 new foundation classes. Does this
mean more "framework" type development?
Answer from randybr_ms_ms:
VPF6 has a new Application Wizard which generates a
new project with application framework. The framework,
which is open architecture, allows use of many of new
foundation classes. The classes also have samples of
how to use new things
baze.podataka.276guta,
Visual FoxPro 6.0 Live Chat Part 2
----------------------------------
Host Susan_MS says:
Paul_Rec_ says:
Is there a Visual FoxPro 7.0 in the works? What will
be its main new feature?
Answer from RobertGreen_MS_ms:
We are, as we type, planning future releases of
Visual FoxPro. What would you like to see in the product?
Host Susan_MS says:
Lindy_ says:
Visual Basic has a command "NOTHING" that is used by
some object libraries to disassociate an object variable
from an actual object. Has this command, or something
similar, been added to Visual FoxPro 6.0?
Answer from RobertGreen_MS_ms:
Can't you set the objects to .Null. and achieve the
same thing?
Host Susan_MS says:
cybrdyne_ says:
>All MS betas are available through MSDN
universal.< I have MSDN universal. When shall we expect
the beta?
Answer from RobertGreen_MS_ms:
Real soon now.
Host Susan_MS says:
bwalter_ says:
Is there a chance there will be any bug fixes to
Visual FoxPro 5.0 before Visual FoxPro 6.0 is released?
Answer from SusanG_MS_ms:
The last release of Visual FoxPro 5.0 was in Visual
Studio's Service Pack 3. No interim versions will be
released before Visual FoxPro 6.0.
Host Susan_MS says:
FredBert_ says:
What will OS(1) return under Win98?
Answer from AllisonK_MS_ms:
Windows 4.10
Host Susan_MS says:
Bill_Anderson_ says:
Can you tell us what Visual FoxPro 6.0 has that
would make it worth my while?
Answer from _ms:
They've added a whole bunch of stuff but it
would take too long to explain. I can type No in two
keystrokes ;)
Host Susan_MS says:
Ed_ says:
Where can independent people join beta programs?
Answer from RobertGreen_MS_ms:
Email betareqŽmicrosoft.com.
Host Susan_MS says:
Kendall_ says:
Why is making the Beta available to experienced
developers who are not attending DevCon so difficult?
Answer from RobertGreen_MS_ms:
We can't support a beta program of unlimited size. We
have an official process for adding people to the beta that
we follow. We have both experienced and new developers
in our betas. We are giving out the beta at DevCon as a
perk for attending.
Host Susan_MS says:
Trini says:
What features supported in new framework?
Answer from randybr_ms_ms:
The new framework has all the glue you need to handle
common application tasks such as managing forms,
toolbars and menus. It's also smart to detect unsaved
buffered data when you close forms/quit application. A
number of common application elements are built-in such
as Splash screen, About dialog, Favorites menu, Password
logins, Quick Start dialog, navigation toolbars and
menu, etc. It's very powerful and easy to use.
Host Susan_MS says:
Serge_ says:
Does FoxPro 6.0 have the same advanced programming
aids as Access 97?
Answer from RobertGreen_MS_ms:
Which one are you looking for?
Host Susan_MS says:
bwalter_ says:
I attended several Microsoft Sponsored Developer Days
over the last 8 months. Visual FoxPro was almost never
mentioned and was even missing from slides of Visual Studio
showing all the other products. Is this going to change
this coming year?
Answer from RobertGreen_MS_ms:
Yes.
Host Susan_MS says:
DaveBarrows_ says:
I just joined the conversation. I'm not at DevCon.
How can I get a list of new Visual FoxPro 6.0 features?
Answer from RobertGreen_MS_ms:
The various 3rd party magazines and newsgroups/list
servers will have lots of details now that the 3rd party
NDA has been lifted. We will have more information on
our Web site later in the summer when we are closer to
shipping.
Host Susan_MS says:
wendy_ says:
Does Visual FoxPro 6.0 provide any tools for trapping
memory leaks?
Answer from randybr_ms_ms:
Visual FoxPro has SYS() functions for detecting
memory usage.
Host Susan_MS says:
Ron_ says:
Is Microsoft committed to Visual FoxPro? In the
press? In # of developers?
Answer from RobertGreen_MS_ms:
Yes, Yes, and Yes. As for press, have you read last
week's online reviews of Visual FoxPro 6.0 in Information
Week and InfoWorld? They loved the product and had very
good things to say about it!
The InfoWorld review should also be in the print magazine
this week. As for developers, we have over 500,000 FoxPro
developers worldwide and we are totally committed to them.
Host Susan_MS says:
Ed_Watkins_ says:
Can a Visual FoxPro database be updated from VB via
ADO?
Answer from randybr_ms_ms:
Sure. ADO includes an ODBC OLE DB provider which uses
the VPF ODBC driver.
Host Susan_MS says:
Tim_ says:
Will Visual FoxPro 6.0. allow you to place toolbars
on any form not just the main window?
Answer from randybr_ms_ms:
Just like VFP5, you can place toolbars and menus on
Top-Level windows (ShowWindow=2). If you want toolbars on
normal windows, you can use an ActiveX control.
Host Susan_MS says:
FredBert_ says:
Are the Migrating FoxPro/Access applications to SQL
Server seminars going to be held in SMALL towns like
Houston, TX?
Answer from RobertGreen_MS_ms:
That is mostly up to the local offices. We make those
seminars available to any field office that wants to have
them. Call your local office and let them know
you want them to give the seminars.
Host Susan_MS says:
jsmock_ says:
Will there be any discussion of bugs and plans to
address them or is this strictly a cheerleading session
for the faithful?
Answer from RobertGreen_MS_ms:
No. Microsoft Technical Support is your best resource
for that. They have the bug database at their ready and so
they can look up an issue and see if it has been reported
before, if it has workarounds, etc. We don't have those
resources.
Host Susan_MS says:
bruceg_ says:
What Web Support features have been added?
Answer from randybr_ms_ms:
We've improved our server story for better use with
ASP applications. We have a new Save As HTML menu item
which uses our new GENHTML engine. You can generate HTML
from Data, Forms and Reports. There is also a new Web
Publishing Wizard with completely open architecture.
Host Susan_MS says:
GLongtin_ says:
2nd time-OLEDB driver for DBC's, ADO record set
object support? If so, in what way?
Answer from RobertGreen_MS_ms:
OLEDB driver for DBCs-excellent idea, under
consideration.
ADO record set support-complete via code.
Host Susan_MS says:
Puck_ says:
26Again:Q1: What are the chances for Visual FoxPro
developers to get a pre-release before the product
ships?
Answer from TomC_ms:
The only way would have been to come to DevCon. All
DevCon attendees are receiving the May Pre-Release.
Alas, it is too late for that now. Sorry.
Host Susan_MS says:
bwalter_ says:
In future Visual Studio Service Packs will the Visual
FoxPro updates still be installed two times each time you
run the update like in service pack 1 and 2 and 3?
Answer from SusanG_MS_ms:
The SP Setup Wizard was checking the registry for
Visual FoxPro 5.0 *and* for 5.0a, so it listed Visual
FoxPro twice in the dialog if it found both in the
registry.
Host Susan_MS says:
dino_ says:
Can we get GUID support???
Answer from randybr_ms_ms:
What do you mean here? You can already call a Windows
API routine to generate a new GUID.
Host RobertGreen_MS says:
We have about 10 minutes left in this chat.
Host Susan_MS says:
Ed_Watkins_ says:
Can ADO be used from VB to access and update a Visual
FoxPro database?
Answer from RobertGreen_MS_ms:
Yes, via the Visual FoxPro ODBC driver.
Host Susan_MS says:
FredBert_ says:
Wish List, how about sending report output to HTML or
a graphic file independent of a print driver.
Answer from SusanG_MS_ms:
In Visual FoxPro 6.0 you can report output to HTML.
Host Susan_MS says:
DaveBarrows_ says:
This is not a joke, but a serious question hoping
Microsoft will come clean with a serious answer: what about
Visual FoxPro Mac? Is it dead? Will it forever remain 3.0?
Answer from RobertGreen_MS_ms:
We actually have come clean with a serious answer on
this, several times. However, I am happy to repeat it
here. <vbg> There will be no more Mac versions of
Visual FoxPro. This is strictly an economic decision based
on low sales of the 3.0 product and the general state of
the Mac market. This was not a happy or easy decision
on our part.
Host RobertGreen_MS says:
We are wrapping this up now. Last chance for
questions.
Host Susan_MS says:
LTD_ says:
Binding to COM Interfaces?
Answer from randybr_ms_ms:
Visual FoxPro 6.0 now supports dual interfaces so you
get both early-binding and IDispatch.
Host Susan_MS says:
cybrdyne_ says:
If you have an object reference, say
thisform.oSomething = an object, and you
set thisform.oSomething = .F. or event .NULL. (like people
are suggesting) doesn't that just change the pointer and
the actual object is still in memory somewhere? Or is
there some sort of recycler working in the background?
Answer from randybr_ms_ms:
Yes. It is still in memory unless you issue a CLEAR
ALL or CLEAR CLASS <classname>. We cache the object
in memory for performance benefits since you may need to
recreate the object right after.
Host Susan_MS says:
TomDeMay_ says:
Does Visual FoxPro 6.0 provide any tools for trapping
memory leaks?
Haven't used it, but try Bounds Checker.
Answer from TomC_MS_ms:
Actually, because of how Visual FoxPro manages and
reuses memory to increase speed, BoundsChecker will report
many false positives. The best bet is to use SYS(1016) to
monitor internal user memory while doing your test
in a loop. For any COM memory leaks, use the task manager
or perfmon. If using DLL servers, any leak will be seen on
your process as the memory usage slowly increasing. If
using EXE servers, a leak might be seen in your client
process, the server process, or RpcSs.exe.
Host Susan_MS says:
dino_ says:
How can I create a GUID in Visual FoxPro???
Answer from randybr_ms_ms:
Use Windows API routine (DECLARE DLL). I don't recall
exact one off-hand.
Host Susan_MS says:
Michael_Chean_ says:
Will Visual FoxPro 7 be released at the next DevCon?
Answer from RobertGreen_MS_ms:
Are you freaking kidding me? <vbg> No way!!!! We are
going to release 6.0 later in the summer, and we sure
aren't going to be ready to do another version
less than a year later! Aye caramba!
Host Susan_MS says:
bruceg_ says:
How about the ability to define a calculation as the
source for a text field?
Answer from SusanG_MS_ms:
You have this functionality in 6.0 by using the new
Access and Assign methods.
Host Susan_MS says:
inforsis_ says:
MsGraph continues in Visual FoxPro 6.0?
Answer from SusanG_MS_ms:
Yes and no. We will no longer be shipping MSGraph 5
and we won't be shipping MSGraph 8 with Visual FoxPro. So
in order to create graphs you will have to
install Graph 8 from some other source. The Setup Wizard
will, however, let you ship the runtime of Graph 8.
Host Susan_MS says:
Rodolfo_ says:
Could I pass my business objects between a client and
a server DCOM Visual FoxPro component?
Answer from TomC_MS_ms:
Yes. As long as it is a regular com object, it can be
marshaled across the net using DCOM. You can even
instantiate Visual FoxPro.Application over DCOM,
and then bring up a project, and use
_Visual FoxPro.ActiveProject.Build() to build your
application on that remote machine.
Host Susan_MS says:
Puck_ says:
John: so, why can't we apply anymore to enter the
beta?
Answer from RobertGreen_MS_ms:
The beta has been closed for several months.
Unfortunately, we don't have the resources to support
betas of unlimited numbers.
Host Susan_MS says:
PRobinshaw_ says:
Any developments in the report writer & menu builder?
Answer from randybr_ms_ms:
What kinds of enhancements would you like to see?
Host RobertGreen_MS says:
Thanks all for attending this. We hope you found it
useful and will join us again sometime soon.
baze.podataka.277guta,
SYBASE INTRODUCES WAREHOUSE STUDIO
----------------------------------
Delivers New Integrated Product Set for Powerful Data Warehouse
Driven Business Solutions
WASHINGTON, DC, May 4, 1998 -- Sybase today introduced Warehouse
Studio (TM), an integrated product set for delivering powerful
enterprise or departmental data warehouse driven business solutions.
Warehouse Studio provides a set of design, transformation, database,
meta data management and administration capabilities optimized to meet
customers' data warehousing needs. Warehouse Studio enables organizations
to deploy business solutions faster and at a lower cost, while providing
the flexibility and scalability to accommodate global, enterprise
requirements. The announcement was made at the International Sybase
User Group Conference being held here this week.
For enterprise-wide data warehouse deployments, Sybase announces the
Enterprise Warehouse Option to Warehouse Studio, which adds a central
data consolidation store and fast, reliable data movement capabilities.
In addition, Sybase is offering Warehouse Studio Extensions that
provide capabilities for broad data access and integration, on-line
analytic processing (OLAP), Web connectivity, and voice recognition.
Sybase also offers industry-leading data warehouse consulting services
through its worldwide Professional Services organization. With these
options, Sybase users can easily customize Warehouse Studio to meet
their specific business requirements.
"Organizations are looking to vendors to help them deploy decision-making
systems more quickly and at a lower overall cost," said David Boswell,
vice president and general manager of Data Warehousing for Sybase.
"Warehouse Studio is designed to deliver a rapid return on their
data warehousing investments, and provides the flexibility to accommodate
the inevitable changes in their business environments."
"With Sybase's Warehouse Studio, we are building exactly the kind of
data repository and data marts that our business users require, while
leveraging all of the systems and the data we already have," said
Tim Regan, manager, Advanced Information Development, Federal Express.
"By providing access to the information our users need, the way they need
it - with minimal cost and time - Sybase has taken a great deal of the
complexity and the risk out of our decision support system development
project. In addition, we are positioned to accommodate the inevitable
growth and evolution of our decision support environment as the business
requirements change."
Warehouse Studio increases the value of data warehouse-based
business solutions by providing reduced total cost of ownership and
faster time to deployment, with features including:
Integration -- A comprehensive product set delivered and
supported by a single vendor, centrally installed, interoperability
tested and meta data driven enables organizations to think globally and
act locally;
Speed -- Intuitive development tools accelerate deployment,
while high-performance data management technologies process information
requests up to 100 times faster than other solutions;
Flexibility -- Data management that is optimized for different application
needs leverages existing systems, and gives IT departments the ability
to distribute or centralize data processing as appropriate, and business
users the opportunity to ask "anything from anywhere;"
Resource Efficiency -- A highly productive environment that easily
accommodates specific application requirements and efficiently uses
hardware while reducing database administrator support requirements.
Price and Availability
Sybase's Warehouse Studio will be generally available in the second
quarter of 1998 on Sun Solaris, IBM AIX, HP HP/UX, Digital UNIX, and
Windows NT platforms. In addition, Sybase Professional Services,
with its network of more than 1,200 professionals worldwide, provides
integration and implementation expertise for Warehouse Studio. Pricing
for the Warehouse Studio, the Enterprise Warehouse Option, and extended
features will be announced later this quarter.
baze.podataka.278vvaske,
HELP !
Greskom (ili gluposcu ?) sam obrisao fajl DAO2016.DLL i sad' mi
ACCESS 2.0 ne radi
A neophodan mi je
moze li to neko da mi posalje ?
10x unapred !
vvaske
baze.podataka.279stemil,
Hi :)
Jel ima neki dobar poznavalac DBase III+ pa da mi izvuče ime i lozinku iz
ovog fajla prikačenog za poruku ?
Ajd ko mi ovo završi može komotno da traži šta god oće !
pozdrav
Miki
lozinke.dbfbaze.podataka.280rdejan,
-> #279, stemil>> ime i lozinku iz ovog fajla prikačenog za poruku ?
Fajl ne sadrži ime, niti lozinku. Pretpostavljam da se koristi
kad obrazac za neki upit (jer sadrži tekst 'Lozinka', 'Ime' i
još nešto), dok se sama šifra kontroliše unutar programa.
Možda za ovo grešim, ali sam siguran da se lozinke ne stavljaju
u .dbf format. :)
Pozdrav, Dejan
baze.podataka.282stemil,
-> #280, rdejan> Možda za ovo grešim, ali sam siguran da se lozinke ne stavljaju
> u .dbf format. :)
Ajd molim te pogledaj dal možeš u ovom fajlu da nadješ to Ime i Lozinku.
Nadam se da ćeš moći, i ako ne misliš da bi trebao ovde, onda mi pošalji
na Mail, jer je programčić star ali ima vlasnika a ja ne mislim išta da
zaradjujem s njim. Jednostavno mi treba za ličnu upotrebu !!!
Hvala ti unapred :)
Miki
fajl.zipbaze.podataka.283jujo,
-> #279, stemil#
# Hi :)
# Jel ima neki dobar poznavalac DBase III+ pa da mi izvuce ime i lozinku
# iz ovog fajla prikacenog za poruku ?
# Ajd ko mi ovo zavrsi moze komotno da trazi sta god oce !
#
U pitenju je prazna DBF tabela.
yooyo:
baze.podataka.284sabre,
-> #283, jujo>> U pitenju je prazna DBF tabela.
Bas prazna... :)
baze.podataka.285nenadt,
u dokumentaciji za DBF baze stoji ovo:
" Data type Data record storage
Memo 10 digits representing DBT block number "
zna li neko sta tacno ide u tih 10 bajtova
baze.podataka.286guta,
---------------------
Potreban programer:
---------------------
- Iskustvo u Oracle-u (PL/SQL), verzije 6 i više
- Dobro poznavanje engleskog jezika
Za rad na određeno vreme u inostranstvu (Nemačka), sa mogućnošću
produženja rada u slučaju da je poslodavac zadovoljan. Radno mesto
se nalazi u Štutgartu, projekat je dužine 4-6 meseci.
Plaćeni dodatni troškovi:
- Avionska karta Beograd-Štutgart-Beograd ili Beograd-Frankfurt-Beograd
- Stan
- Prevoz do radnog mesta
Obezbeđena radna viza.
Prijave sa kratkom biografijom i brojem telefona poslati na mail, ili
se obratiti direktno telefonom:
011/627-813
011/637-625
011/301-5095
011/301-5096
011/301-5097
od 9 do 17h, svakog radnog dana.
baze.podataka.287nenadt,
ima li nekog ovde ko je radio sa PARADOX 4 paketom?
interesuju me informacije oko kreiranja PARADOX.NET fajla
baze.podataka.288vtosev,
-> #287, nenadt> ima li nekog ovde ko je radio sa PARADOX 4 paketom?
> interesuju me informacije oko kreiranja PARADOX.NET fajla
Pitaj ovde ili mozda bolje na mail: vtosev@eunet.yu. Retko citam ovo.
baze.podataka.289sane,
Da nema neko neki tutorial ili bilo shta na tu temu o osnovama
programiranja u Visual Basicu, ili mozhda ako neko ima knjigu pa bi
bio ljubazan da mi pozajmi da fotokopiram..
baze.podataka.290nenadt,
zna li neko sta je sve potrebno od fajlova da bi se
Microsoft DAO 3.0 preneo na ciljnu (korisnicku) masinu? Ako neko
ima vec gotovu instalaciju gore pomenutog neka je posalje u mail
(URL takodje pasuje).
Unapred zahvalan,
pj
baze.podataka.291vvaske,
Čita li neko ovu temu ?
Moj prijatelj ima jedno pitanje...
Muči se sa PARADOX-om, pa ga interesuje, kad napraviš aplikaciju, i
želiš da je daš/prodaš nekome, ima li načina da to učiniš bez da
krajnji korisnik na svom disku ima i Paradox.exe (pdoxwin.exe ili
kako se već zove..)
Možda sam OVO PREVIŠE ZAMRSIO . . .
Da uprostim ..
Runtime za Paradox for WIN, bilo koja verzija... postoji li to ..
Pozdrav,
Vvaske
baze.podataka.292voyager,
Problem:
Imam bazu tipa Paradox 7. Tokom proteklih dana ja bazu punio
podacima, punio, punio...i resim ti ja da pola pobrisem. Tada sam
ustanovio da je baza pre brisanja imala 500kb i posle brisanja isto
500kb.
Pitanje:
Jel zna neko o cemu se radi?
VoYaGeR
baze.podataka.293saxon,
-> #292, voyager> Imam bazu tipa Paradox 7. Tokom proteklih dana ja bazu punio
> podacima, punio, punio...i resim ti ja da pola pobrisem. Tada sam
> ustanovio da je baza pre brisanja imala 500kb i posle brisanja isto
> 500kb.
Ih, pa ovo cak i ja znam...
Kad obrises podatke iz baze, slobodni prostor na disku zaista nece biti
uvecan u skladu sa tvojim ocekivanjima. Prostor koje su zauzimali zapisi
koje si izbrisao bice iskorisceni za upis novih, onda kada ih budes
napravio. Za utehu, jedno duze vreme velicina tvoje baze ostace
nepromenjena :) sve dok ne potrosis prostor oslobodjen brisanjem. Ako bi
od Paradoxa zahtevao da ti svaki obrisani zapis vrati u vidu slobodnog
prostora na disku, to bi od njega zahtevalo da non-stop siftuje
levo-desno veliku kolicinu podataka po disku ne bi li zakrpio rupu od
kilobajt-dva podataka izbrisanih usred baze.
Za utehu, vecina "normalnih" baza podataka ima komande poput "Compress
Data", "Optimize Database" ili "Pack" koje definitivno svode zauzet
prostor na disku na najmanju mogucu velicinu. Nekada je ova operacija
cist luksuz sa minimalnim dobitkom, a nekada nuzan poduhvat. Ko je nekad
pravio aplikaciju u Access-u, pa na kraju uspeo da bazu/program od 3Mb
svede na tricavih 500kb, zna o cemu pricam.
baze.podataka.294voyager,
Da li postoji neki nacin da se baza (Paradox) zastiti password-om
tako da je moze otvarati samo program koji "zna password", npr.
program pravljen u delphiju?
VoYaGeR
baze.podataka.295kojai,
-> #294, voyagerPa sa Delphiem dobijas program Database Desktop gde kreiras baze... Tu imas
opciju da namestis sifru... U Delphiu kada ucitavas pita te za sifru, ali to
mozes izbeci tako sto u mesto za....aa.(ne znam tacno) upises USERNAME=...,
PASSWORD=... Provalices...
Baza se kriptuje sifrom, znaci kljuc je sifra, tako da predstavlja dobru
zastitu... :)
Isa
baze.podataka.296obren,
-> #292, voyager> Imam bazu tipa Paradox 7. Tokom proteklih dana ja bazu punio
> podacima, punio, punio...i resim ti ja da pola pobrisem. Tada sam
> ustanovio da je baza pre brisanja imala 500kb i posle brisanja isto
> 500kb.
>
> Pitanje:
>
> Jel zna neko o cemu se radi?
Brisanjem si samo označio obrisane slogove u bazi kao slobodne, tako
da sada budući podaci koje ubaciš u bazu mogu da idu preko njih.
Ako želiš da smanjiš veličinu baze, pronađi u menijima opciju poput
"Compact database" koja izbacuje te "rupe" i ostavlja samo validne
tj. popunjene slogove.
Ova operacija se svodi na kopiranje podataka u novu bazu, brisanje
stare baze i davanje imena stare baze novoj bazi.
baze.podataka.297obren,
-> #294, voyager> Da li postoji neki nacin da se baza (Paradox) zastiti password-om
> tako da je moze otvarati samo program koji "zna password", npr.
> program pravljen u delphiju?
Moralo bi da može, Senior koristi Paradox Engine (kernel na kome
počiva sam Paradox kao paket) i on omogućava kriptovanje baze.
baze.podataka.298kenza,
-> #292, voyager> ustanovio da je baza pre brisanja imala 500kb i posle brisanja isto
> 500kb.
> Jel zna neko o cemu se radi?
U Access-u se problem resava compact-ovanjem baze, pokusaj da
pronadjes neku slicnu opciju.
baze.podataka.299kojai,
-> #297, obren>> Moralo bi da moze, Senior koristi Paradox Engine (kernel na kome
>> pociva sam Paradox kao paket) i on omogucava kriptovanje baze.
Ne razumem? U DB Desktopu se namesta sifra(najlakse), cela baza se kriptuje
sifrom(dakle kljuc je sifra-najbolja zastita) i nivoi pristupa se daju po
sifri... Sta ima jednostavnije?
Isa
baze.podataka.301madamov,
-> #292, voyagerJel nabavio neko Delphi 4.0 ? Ima li nekih poboljsanja ?
Goran.
Zna li neko kako mogu vise edit box-ova da stampam na jednom
papiru, po nekom mom rasporedu, koji ja zelim ? Zna li neko kako se
stampa DBGrid ?
Goran.
> Jel nabavio neko Delphi 4.0 ? Ima li nekih poboljsanja ?
Cuo sam da Delphi 4.0 ne radi za S3 virge grafickom, ali na sajtu
ima patch. Toliko ja znam o cetvorci :)
>> > Jel nabavio neko Delphi 4.0 ? Ima li nekih poboljsanja ?
Mogu samo reci da program rbaze.podataka.303uuud,
Jel nabavio neko Delphi 4.0 ? Ima li nekih poboljsanja ?
Goran.
Zna li neko kako mogu vise edit box-ova da stampam na jednom
papiru, po nekom mom rasporedu, koji ja zelim ? Zna li neko kako se
stampa DBGrid ?
Goran.
> Jel nabavio neko Delphi 4.0 ? Ima li nekih poboljsanja ?
Cuo sam da Delphi 4.0 ne radi za S3 virge grafickom, ali na sajtu
ima patch. Toliko ja znam o cetvorci :)
>> > Jel nabavio neko Delphi 4.0 ? Ima li nekih poboljsanja ?
Mogu samo reci da program radi fenomenalno...
>> Cuo sam da Delphi 4.0 ne radi za S3 virge grafickom, ali na sajtu
>> ima patch. Toliko ja znam o cetvorci :)
Xex... Sto ne bi radio? Sa starim Diamondima radi, a to je takodje
S3 chipset...
Isa
Zna li neko kako mogu program (Delphi 2.0) da minimizujem u taskbar
(Win9x) ???
Hvala.
Vidim da je ovde tesko dobiti odgovor na pitanje i pored toliko
molbi, ali ajde da postavim jedno pitanje (mozda ce se neko konacno
smilovati da mi odgovori).
Dakle, treba napraviti program koji izracunava sledece :
d:=sqrt(sqr(x2-x1)+sqr(y2+y1))
x1,x2,y1,y2 se unose preko edit boxova. E sad ja znam za onu
proceduru Val, koja konvertuje String u Integer, ali problem je u
tome sto funkcija SQRT radi samo za Real tip a ne za integer. I sad
ne znam sta da radim.
Ajde ljudi smilujte se, ako nista bar zato sto me nije mrzelo
da pisem ovoliku poruku. ;))
Goran.
> d:=sqrt(sqr(x2-x1)+sqr(y2+y1))
> x1,x2,y1,y2 se unose preko edit boxova. E sad ja znam za onu
> proceduru Val, koja konvertuje String u Integer, ali problem je u
> tome sto funkcija SQRT radi samo za Real tip a ne za integer. I sad
> ne znam sta da radim.
Pa treba da stavis u programu da su ti promenjlive float, a mislim
da se to u delphiju zove Real, ako stavis integer onda ces moci
da unosis samo celobrojne vrednosti. Razlog zasto nece SQRT je taj,
sto ako izaberes integer, izlaz isto mora da bude integer, sto je
ok ako recimo uneses 4, ali ako unesec 5 tu vec u rezultatu imas,
i decimalni zarez, a to nije integer vec float, neznam kako se to radi
u delfiju, ali recimo da ti ulazi bude integer a izlaz float, to bi onda
bilo ok...
>> u delfiju, ali recimo da ti ulazi bude integer a izlaz float,
Sve je to OK, ali ne postoji, koliko sam ja uspeo da provalim,
procedura koja konvertuje iz Stringa u Float. :(
Val konvertuje iz stringa u integer, a Str iz integeraa u string, a
ne znam kako da to isto radi za float (string->float).
Goran.
> Vidim da je ovde tesko dobiti odgovor na pitanje i pored toliko
> molbi, ali ajde da postavim jedno pitanje (mozda ce se neko konacno
> smilovati da mi odgovori).
> Dakle, treba napraviti program koji izracunava sledece :
> d:=sqrt(sqr(x2-x1)+sqr(y2+y1))
> x1,x2,y1,y2 se unose preko edit boxova. E sad ja znam za onu
> proceduru Val, koja konvertuje String u Integer, ali problem je udijak.rarbaze.podataka.305zdravkod,
Jel postoji neki alat za popravljanje Paradox 5.0 baze podataka.
Baza radi, samo je nemoguce pristupiti nekim poljima...
Zdravko
baze.podataka.306kiklop,
-> #305, zdravkod> Jel postoji neki alat za popravljanje Paradox 5.0 baze podataka.
> Baza radi, samo je nemoguce pristupiti nekim poljima...
>
> Zdravko
Ima. Trenutno nisam kući ali poslaću večeras.
BTW pogledaj na www.torry.ru ima određeni broj komponenti koje
odrađuju taj posao a džabe su.
Darko
baze.podataka.307mansell,
Tema Access 2000:
- Kako napraviti run-time verziju (da li postoji poseban program koji
to radi ili mora preko switcheva u komandnoj liniji) ?
- Na koji je nacin potrebno zastiti .mdb (.mde) da korisnici ne bi mogli
da vide kod ili da nesto drugo cackaju ?
p.s. Moze i varijanta za verziju 97.