社区
DataWindow
帖子详情
PB数据窗口对象中的update properties 中table to update 选择不到表或选择的不能更新。
lztqy
2016-03-31 11:46:08
如题所示,求解。查询语句比较复杂,得使用子查询,别名。
...全文
873
4
打赏
收藏
PB数据窗口对象中的update properties 中table to update 选择不到表或选择的不能更新。
如题所示,求解。查询语句比较复杂,得使用子查询,别名。
复制链接
扫一扫
分享
转发到动态
举报
写回复
配置赞助广告
用AI写文章
4 条
回复
切换为时间正序
请发表友善的回复…
发表回复
打赏红包
WorldMobile
2016-04-05
打赏
举报
回复
如果用子查询,不要用别名,就可以选择到表了,如果用了别名,建议你使用要更新表的表名,如你的子查询的那个abc,你可以用class
fengxiaohan211
2016-04-01
打赏
举报
回复
使用视图可以吗?不要写那么多的关联
lztqy
2016-03-31
打赏
举报
回复
引用 1 楼 jlwei888 的回复:
这也用不着子查询啊,改了就行了
这个是举个例子 ,实际情况下,比较复杂,用子查询较方便就能得到想要的结果。可是在这边就过不了。
jlwei888
2016-03-31
打赏
举报
回复
这也用不着子查询啊,改了就行了
用
数据
窗口
实现多
表
更新
示例
pb
9
数据
窗口
数据
源来自两个或两个以上的
表
,相当于多个
表
连接建立的一个视图,对于这种
数据
窗口
,
PB
默认是
不能
修改的。当然我们可以通过设置它的
Update
属性,
数据
窗口
的
Update
Properties
用来设置
数据
窗口
是否可
Update
、可
Update
的
表
、可
Update
列等,但
不能
同时设置两个
表
可
更新
;所以当修改它的
数据
项时,我们
不能
简单地用dw_1.
update
()来
更新
table
,我们可以在程序
中
设置
数据
窗口
可
更新
的一个
表
A(及其可
更新
列),其他
表
为不可
更新
,
更新
完
表
A后,再设置另一
表
B为可
更新
,
表
A设置为不可
更新
,依次类推。
VB编程资源大全(英文源码
数据
库)
1 , datafile.zip
"This sample demonstrates how to do file input and output using Visual Basic. The sample creates a new database file and allows you to view, add, or delete records in this database."
2 , dbprint.zip
This demonstrates how to print data from a database.
3 , edittbls.zip
This is an EXCELLENT example on how to edit database
Table
s through VB.
4 , graphdb.zip
This demonstrates how to graph information from a database to a picturebox.
5 , ClassBuilder1.zip
Class Builder - reads SQL Server or Access database and creates a class of the selected
table
6 , adoView1.zip
ADO viewer. Retrieve all columns, querys and fields of a database and put them in a TreeView(using OpenSchema ADOConnection method)
7 , imagechunk1.zip
This application will save JPG,BMP,GIF files in your database and allows you to fetch the same. Code example for saving and fetching the same in oracle and sql is also given.
8 , DBImpExp.zip
A utility to import/export Access database from/to other application formats, e.g. Excel and text files. With sample files and help, as well as ample remarks.
9 ,
pb
_test.zip
Test project illustrating high performance Data Access for SQL Server using ADO command objects and Stored Procedures for Insert,
Update
, Delete and Select. Two methods for Selects are shown
10 , Employees.zip
This is a database project, for storing employees data.
11 , DBProject2.zip
New version of DBProject. Allows you view, scroll through, and edit an access database.
12 , adoview.zip
ADO Viewer,This code retrieve all columns, querys, fields of a database(Access, SQL Server, etc...)
13 , Cheques2.zip
New version of Cheques program. Must see...
14 , ADOSQLcodeGenerator.zip
SQL and ADO Code Generator. Generate SQL statement and ADO Code Connection without the use of an ADO Data Control.
15 , client.zip
This application is about programming with Client Side Cursors.
16 , AccessSecurity.zip
An Access97 security tool. Replaces going into Access97 and switching between security forms.
17 , DatabaseViewandEdit.zip
Do about anything with Access databases. View, edit, export contents to Word or Excel, etc., etc.
18 , VBSales.zip
This is a complete database program for sales which help you to create purchase order, Invoice, etc.
19 , accidents.zip
A programme meant to add, edit,delete,and searching data. It includes how to show statistics regarding the accidents information.just try it. It is handy in studying database programming.
20 , MySQLExplorer.zip
Explorer for MySQL Data Base.You can retrieve and execute your query.
21 , ICDBaseSource115.zip
DAO based database program with many features in it
22 , ICDBSourceBeta115.zip
teach people just beginning with databases and also i am new to databases so this is pretty well commented.
23 , Diary.zip
This application everything you need.t has a CALCULATOR.It has TIME & DATE u can even set the system time
24 , L_datab.zip
The functions are for open Databases including passwords, creating Recordsets , executing SQL statements, renaming
table
s and many more.
25 , CodeGen.zip
VB code generator,The application currently generates data classes for Access '97 databases.
26 , dbexample.zip
The best part about using a MS JETDB EnGINE4 is that the DB can be accessed through a network.
27 , ComboLookup.zip
Zip Code Database Is A Program To Find Zip Codes By Using A Lookup Field.
28 , UDL.zip
This is a class that lets you create and edit UDL files
29 , qbd-dbCoder131.zip
This code shows how to take data from a VB database application and place it into an Excel spreadsheet.
30 , Family_v2_upload_Apr_05_2000.zip
This is a family address book program created using VB6.
31 , datsearch.zip
Application which searches an Access database for a specified search term entered by the user.
32 , DBTextGrid.zip
This program is the modification of my previous Textgrid.Now you can Add, Modify, Delete, View, Save data to/from your database with this Grid. The grid was formed with array of text boxes.
33,txtgrid.zip
This program creates text box array dynamically and loads the database fields onto it.
34,DAOLike.zip
This program Demonstrates how to use LIKE operator in Jet SQL Query (uses DAO).
35,xmlcreator.zip
This project is a demonstration of how to convert a recordset into an XML format file. Its well documented and more XML stuff to come along.
36,compmdb.zip
This program will allow the user to select a MDB file to compact. Its then backed up just in case, compressed and then the original is deleted before the new compacted version is moved back in place of the original.
37,dbinfo.zip
We've written this mainly for when we develop databases, but really you could adapt it for productive use too. By supplying a DSN entry, it will attempt to connect to that database and list all the
table
s in it. When you click on a
table
, it lists all
38,3a.zip
An Inventory System, you can add, edit, sort, find, delete, print, change your password and create a backup of your database
39,A417Source.zip
Full original RANDOM DATA INDEXING (SY-32)METHOD),Faster DATA access than a classical database application. the 1st source of new indexing method (SY-32)
40,student.zip
This is Student Administration Project , u can administrate student through this programme in any institute when u run the programme please use password "mars3" then u can run please check it.
41,ADOViewer.zip
ADO DataBase Viewer. Can open multiple concurrent databases from seperate providers. Works with Access, SQL Server and DSN. I included the ODBC Logon from VB6 so it should be able to hook up to any data provider that supports ADO.
42,rptparam.zip
Passing parameters with data reports. I have set two parameters and passed them during run time.Open with VB6.
43,CompactRepair.zip
A small application that shows you how to compact and repair a Microsoft Access mdb or mde using ADO (JRO).
44,Ledgerinvb5.zip
This is simple GL ledger Project, again a database program. It has an interesting part if you click About button. Must see it.
45,AdoSort.zip
Ado Data Sort Control will display your data from database, filter, sort (up to 3 levels) all in HFlexGrid!!!
46,adoxml.zip
Use ADO to convert database records into an XML file. All users must have MSXML.dll version 3.0, and Internet Explorer 5.5.
47,DataCntl.zip
Simple application that shows how to use the Data Control to connect to the Biblio.mdb database and display all authors in the Authors
table
.
48,MyTool.zip
An SQL Query tool for SQL Server or Oracle.
49,fab15.zip
Complete Database Address book With Lots Of New Facilites.....下载 Now.
50,DataBaseViewer.zip
DataBase Viewer is a program that lets you to look at your database files. It opens the recordsets in a
table
for easy viewing and also has a percents and progress bar to show the exact loading progress of the RecordSet.
51,Dynarep.zip
This program generates a dynamic datareport during runtime without using any DataEnvironment object. I have passed the datasource and recordset
properties
during run time. Opens with VB6.
52,EditUDL2.zip
This is a newer version of the Edit UDL class. This version 2.3 enables you to Create, Edit and Save UDL files either by the UDL
properties
Dialog Box or by a connection string. The class adds some additional
Properties
. The Zip file contains not only the class but a sample project demonstrating the use of the UDL class.
53,ADOclient-side.zip
In a network environment, open a connection to a database, retrieve data, close the connection, work with the data, reopen the connection to communicate with the database again and do a batch
update
.
54,udl2.zip
This application reads universal data link files from disk, creates them, and saves modifications to them to a file. UDL files contain ADO connection information to data sources. Their output can be used as a connection string in your applications.
55,timebilling.zip
This is a full 3-tier dababase application which includes a activex dll project(business objects) and a standard exe(UI).
56,ADODAOpw.zip
Application which shows how to access a password protected Access database using DAO and ADO.
57,DBExplorer.zip
Database explorer for viewing all
table
s and queries in a database. Also includes an SQL editor similar to SQL Query Analyzer.
58,FriendsDb.zip
ADO Database, Improved login and made the program smaller but with the same options as before just a few extra ones with the login such as write the login to the registry instead of just to a ini file also better encryption for the ini file... Now you can save your password as a number, in the previous login the encryption was poor.
59,FriendsDb105.zip
ADO Database... FriendsDatabase Version 1.05 ...
Update
d Again, Added even more error handling and images to the listview box also added a few forms to stay on top. Some major error additions i skipped before, runs much smoother now not that it didn't before.
60,Friends.zip
GREATLY
UPDATE
D: Added much better error handling just to be safer and more neat... Also added more sound so all commands have a sound and upon loading a 3 second wav plays also included is the advanced progress bar and ocx that i found in someone elses source that is great for multiple reasons..
61,FriendsDatabase.zip
My first ADO database, i learned from tutorials on here specifically from Jerry Barnes so i think this would be great for people new to ADO databases to learn from but i suggest finding Jerry Barnes ADO For beginners source because it is incredibly commented on and will surely have you creating ADO within 20 minutes.
62,user_query.zip
The Application basically allows you to connect to any Access Database view records of each
table
, along with the
table
design ,write sql statements on the fly(any dml statement).Most Of The Functionality Of The Application Has Been Automated. A must See..
63,Database.zip
Database application. Must see...
64,Cheque.zip
Cheques. Must see...
65,ICDBaseSource.zip
DAO based database program with many features in it, I also noticed after searching around I seen no databases that supported saving gaming info so I made one witht he ability for saving game info such as favorite game, gaming handle, clan name, clan rank...
66,pizza.zip
Pizza Program. Must see...
67,prjDataEnv.zip
This VB database application shows how to use DataEnvironment in code.
68,Familyv3.zip
This is new version of a family address book that I released some time ago. This time around I mostly use ADO instead of DAO and now the user isallowed to add or remove any category of their choice.
69,AgendaRBC.zip
An Agenda which uses a text database file.
70,project26.zip
Stocks Portfolio.
71,vbasics.zip
This is a database project that uses the VB DBGrid control to display and scroll through all records in an Access database.
72,vbWales.zip
Database app. I did as a college assignment. Only simple stuff but there is some good tab strip code etc...
73,DBProject.zip
Database Viewer application. Allows you to view and scroll through all of the records in a database.
74,dbCoder.zip
Access97 Database Coder. Analyses a database and writes the code required to create blank copy. Two projects dbCoderAddIn.vbp can be compiled as an add-in and will place the code in a new module of the active project.
75,move_vb6.zip
Demonstrates how to use the data control to move through a recordset.
76,ado.zip
Opens an access database using ADO and then displays all records, provider
properties
and error information in a list box.
77,f_119.zip
An example of a bound form using the ADO control(4KB)
78,f_118.zip
Examples of a connectionless recordset(2KB)
ELK/ELFK(7.3 ) 企业
PB
级日志系统实战
Elastic Stack日志系统是目前企业应用广泛的一套日志解决方案。 包含的组件有Filebeat,Logstash,Elastic,Kibana等 本堂课引入Kafka 让Elastic Stack 能适应企业
PB
级的业务日志量并弥补传统ELk架构的不足 ★学完这门课程会获得什么? 首先从零开始教你部署Elastic Stack系统, 详细讲解Elastic产品,包括 Kibana.Logstash,Beats的详细讲解以及Elastic的api操作, 并如何监控如何绘图等。最后结合自己的运维过程
中
的案例讲解,让学员能更加清楚了解原理以及少走一些弯路。 目前我们公司每天产生至少8个T的
数据
量,历史日志保存半年。此教程足以能承担
PB
级的日志收集系统的量。此教程的背景介绍请参阅我的CSDN博客,置顶内容的第一篇博文。
pb
数据
窗口
更新
mysql_如何在
PB
数据
窗口
中
修改
数据
---设置
数据
窗口
的
更新
属性...
如何在
PB
数据
窗口
中
修改
数据
如何在
PB
数据
窗口
中
修改
数据
---设置
数据
窗口
的
更新
属性
数据
窗口
对象
非常强大的原因之一就是能够很容易地修改
数据
库。当用户修改了
数据
窗口
中
的
数据
,插入了新的
数据
行或者删除了
数据
行以后,只要调用
update
()函数就可以将修改了的
数据
保存到
数据
库
中
。但是,这需要一个前提,就是必须设置
数据
窗口
的修改属性。
数据
窗口
要修改
数据
表
,首先清楚
数据
窗口
只能修改一个
数据
表
。当
数据
窗口
的数...
浅谈
PB
Update
Properties
属性
PowerBuilder
中
可以通过
数据
窗口
的
更新
属性(
Update
Properties
)来实现并发控制。打开 DataWindow 画笔板,点击 Rows->
Update
Properties
菜单,进入“Specify Updatae
Properties
”对话框,其
中
“Where Clause for
Update
/Delete”组合框
中
的三个选项就是三种处理
数据
并发问题的策略。 ![...
DataWindow
609
社区成员
20,469
社区内容
发帖
与我相关
我的任务
DataWindow
PowerBuilder DataWindow
复制链接
扫一扫
分享
社区描述
PowerBuilder DataWindow
社区管理员
加入社区
获取链接或二维码
近7日
近30日
至今
加载中
查看更多榜单
社区公告
暂无公告
试试用AI创作助手写篇文章吧
+ 用AI写文章