Results are shown in the Desktop If not visible, use Outshow-Keycode – Ctrl+Shift+Alt (do not mix with Del)īasic Table commands USE – AGAIN SHARED or EXCLUSIVE – IN 0 (not yet used workarea) – ORDER – ALIAS – NOUPDATE (for read-only access!) SET PATH TO – search path for file-based commands Node Views View Definition Browse Results Run Query (select * from view…) Design New Views should be stored in a separate DBC as they otherwise will get lost with next application update!Ĭommand Window & Browse Window The non-visual interface for about everything but escpecially for browsing dataīasic Directory commands CD – MD, RD as well like DOS Other Key Generation – SetSRSKey() – SetPDefKey() – SetPListKey()
Node Stored Procedures Unique Key Generation – GetNewKey()
Vfp cliptext code#
Run Query Define Query Run Query Save Query Copy Query to Clipboard Copy Results to Clipboard AddOn: Copy Results to Excel – if interesting code should be shown Node Tables Shows Table Names Expands to Field Names – does not display comments – can display structure information – Options: Checkbox: Show Column Info – RightClick: Checkbox: Show Col Info
Problem with free tables – not shown in directory view… – you can add them one by one… – we should move all of them to DBCs… Via Configuration File – config.fpw – command = do …Īdd a Connection To a Database Container To a Tables directory To a Microsoft SQL-Server – (local) – over the Internet – available for VFP as a WebServiceĪdd Directories instead Directories to Add: – adds all DBCs of given directory – does NOT add all tables of directory! Via Command Window: – DO home() + „dataexplorer.app“ – … with „-M“
Vfp cliptext how to#
How to call Via Menu: – Tools -> TaskPane -> More Topics DataExplorer –easy way to discover the datamodel and to run queries Command Window – the control center mainly used for browsing data Correct settings in Visual FoxPro 9.0 to avoid confusion within the team Working with the View Designer to create/save basic SQL statementsĭata Explorer A visual tool to navigate in tables and to test SQL-statements VFP-DevCon VFP-Lokal/Develop Framework Visual Extend MVP, MCP, ISV Wizards & Builders GmbH Rainer Becker dFPUG – Online offers – Loose Leaf Magazine Working interactively with Microsoft Visual FoxPro Welcome to SDE Rainer Becker
0 kommentar(er)
